16.20 - SHOW STATISTICS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

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.

Syntax: Optimizer Form



Syntax: QCD Form