15.10 - SHOW STATISTICS - 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

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.

  • table
  • join index
  • hash index

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