SHOW STATISTICS SQL Statement | Teradata Vantage - SHOW STATISTICS - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Reports the SQL text for the Optimizer and QCD forms of COLLECT STATISTICS requests that collected the statistics and optionally reports the detailed or summary statistics.

Privileges

The privileges required to execute a SHOW STATISTICS request depend on the specific type of request you want to submit.

The following table lists the privileges required to submit a SHOW STATISTICS request with a VALUES clause on various database objects.

Database Object Privileges Required
base table SELECT on the base table or its containing database or user.
join index
  • SELECT on the containing database or user for the join index.

    or

  • SELECT on the underlying table set for the join index.

    or

  • DUMP on the join index or its containing database or user.
hash index hash index or the containing database or user for its underlying table.

The DUMP privilege is used to enable an archive of statistics to be reported by a SHOW STATISTICS … VALUES request.

The following table lists the privileges required to submit a SHOW STATISTICS request without a VALUES clause on various database objects.

Database Object Privilege Required
base table base table or its containing database or user.
join index underlying table set of the index or its containing database or user.
hash index underlying table of the index or its containing database or user.

The following table lists the privileges required to submit a SHOW STATISTICS request on various database objects that are protected by row-level security constraints.

Row-level Security-protected Database Object STATISTICS Privilege and the OVERRIDE SELECT CONSTRAINT Privileges Required
base table 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.