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:
- join index
- hash index
You can also use SHOW STATISTICS to report SUMMARY statistics for a table, join index, or hash index.
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.|
||the specified join index.|
|hash index||any||the specified hash index.|
|table that is protected by row-level security||STATISTICS
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.|