HELP STATISTICS SQL Statement | VantageCloud Lake - HELP STATISTICS (Optimizer Form) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Reports the summary statistics that have been collected in DBC.StatsTbl for a table or join index.

Submit a SHOW STATISTICS request and specify the VALUES option to report detailed attributes for the statistics that have been collected for the following:
  • Table
  • Join index

You can also use SHOW STATISTICS to report SUMMARY statistics for a table or join index.

ANSI Compliance

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

Required Privileges

You must have one of the following privileges to perform the standard form of HELP STATISTICS.

Object of HELP STATISTICS Request Privilege Needed
Permanent or global temporary table You must own the table or have any privilege on it.
Volatile table None.
Join index You must own the table or have any privilege on it.
Table protected by row-level security
  • STATISTICS
  • OVERRIDE SELECT CONSTRAINT

Use either the STATISTICS privilege or the SHOW privilege to enable a user to perform HELP or SHOW requests only against the optimizer statistics collected on a specified database object.

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

Row-level Security-protected Database Object Object on Which You Must Have STATISTICS and OVERRIDE SELECT CONSTRAINT Privileges
Base table Base 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.