15.10 - HELP STATISTICS (QCD Form) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

Displays summary or detailed attributes for the statistics that have been collected in the TableStatistics table of the specified QCD database for the 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.

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.

Syntax