Purpose
Reports the summary statistics that have been collected in DBC.StatsTbl for a table, join index, or hash index.
Submit a SHOW STATISTICS request and specify the VALUES option to report detailed attributes for the statistics that have been collected for the following:
- table
- join index
- hash index
You can also use SHOW STATISTICS to report SUMMARY statistics for a table, join index, or hash index.
Privileges
You must have one of the following privileges to perform the standard form of HELP STATISTICS.
| To submit a HELP STATISTICS request on a … | You must have this privilege … | On … |
|---|---|---|
| permanent or global temporary table |
|
the specified table. |
| volatile table | none. | none. |
| join index |
|
the specified join index. |
| hash index | any | the specified hash index. |
| table that is protected by row-level security | STATISTICS and OVERRIDE SELECT CONSTRAINT |
the specified table. |
Use either the STATISTICS privilege or the SHOW privilege to enable a user to perform HELP or SHOW requests only against the optimizer statistics collected on a specified database object.
The following table lists the privileges required to submit a HELP STATISTICS request on various database objects that are protected by row-level security constraints.
| To execute HELP STATISTICS with a VALUES clause on this row-level security-protected database object … | You must have the STATISTICS and OVERRIDE SELECT CONSTRAINT privileges on the … |
|---|---|
| base table | base 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
