Purpose
Reports the SQL text for the Optimizer and QCD forms of COLLECT STATISTICS requests that collected the statistics and optionally reports the detailed or summary statistics.
Privileges
The privileges required to execute a SHOW STATISTICS request depend on the specific type of request you want to submit.
The following table lists the privileges required to submit a SHOW STATISTICS request with a VALUES clause on various database objects.
| Database Object | Privileges Required |
|---|---|
| base table | SELECT on the base table or its containing database or user. |
| join index |
|
| hash index | hash index or the containing database or user for its underlying table. |
The DUMP privilege is used to enable an archive of statistics to be reported by a SHOW STATISTICS … VALUES request.
The following table lists the privileges required to submit a SHOW STATISTICS request without a VALUES clause on various database objects.
| Database Object | Privilege Required |
|---|---|
| base table | base table or its containing database or user. |
| join index | underlying table set of the index or its containing database or user. |
| hash index | underlying table of the index or its containing database or user. |
The following table lists the privileges required to submit a SHOW STATISTICS request on various database objects that are protected by row-level security constraints.
| Row-level Security-protected Database Object | STATISTICS Privilege and the OVERRIDE SELECT CONSTRAINT Privileges Required |
|---|---|
| base table | table or its containing database or user. |
| join index | underlying table set of the index or the containing database or user of the underlying table set. |
| hash index | underlying table of the index or the containing database or user of the underlying table. |
Syntax: Optimizer Form
Syntax: QCD Form
