Reports the summary statistics that have been collected in DBC.StatsTbl for a table or join 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
You can also use SHOW STATISTICS to report SUMMARY statistics for a table or join index.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have one of the following privileges to perform the standard form of HELP STATISTICS.
Object of HELP STATISTICS Request | Privilege Needed |
---|---|
Permanent or global temporary table | You must own the table or have any privilege on it. |
Volatile table | None. |
Join index | You must own the table or have any privilege on it. |
Table protected by row-level security |
|
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 database objects that are protected by row-level security constraints.
Row-level Security-protected Database Object | Object on Which You Must Have STATISTICS and OVERRIDE SELECT CONSTRAINT Privileges |
---|---|
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. |