SHOW STATISTICS SQL Statement | Teradata Vantage - 17.05 - SHOW STATISTICS - 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)

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.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required 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.