HELP STATISTICS SQL Statement | Teradata Vantage - 17.05 - HELP STATISTICS (QCD Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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.

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 QCD form of HELP STATISTICS.
  • 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.