Displays summary or detailed attributes for the statistics that have been collected in the TableStatistics table of a specified query capture database (QCD) for a specified table.
Submit a SHOW STATISTICS request (see SHOW STATISTICS) and specify the VALUES option to report detailed attributes for the QCD statistics that have been collected for a table, hash index, or join index. You can also use SHOW STATISTICS to report SUMMARY QCD statistics for a table, join index, or hash index.
This statement is a Teradata extension to the ANSI SQL:2011 standard.
- Any privilege on table_name.
- Own table_name and have SELECT privilege on the TableStatistics table in QCD_name.
Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against the QCD statistics collected on a specified database object.