17.05 - HELP STATISTICS Syntax Elements (QCD Form) - 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)
CURRENT
Reports extrapolated table-level summary QCD statistics.
database_name
user_name


Name of the containing database or user for object_name if something other than the current database or user.
object_name

Name of a table, join index, or hash index for which QCD statistics information is required.
QCD_name
Specifies that the statistics to be retrieved are found in the TableStatistics table of the specified QCD database.
query_ID

 
Value inserted into QCD.TableStatistics.QueryId by the database.
Each unique composite of query_ID and statistics_ID identifies a separate set of statistics in QCD.TableStatistics for a given column or index.
The default value is 0.
statistics_ID

 
Value inserted into QCD.TableStatistics.StatisticsId by the database.
Each unique composite of query_ID and statistics_ID identifies a separate set of statistics in QCD.TableStatistics for a given column or index.
The default value is 1.
USING MODIFIED
For reporting the modified statistics stored in QCD.TableStatistics.ModifiedStats.
If you do not specify the USING MODIFIED option, the system reports the unmodified statistics stored in QCD.TableStatistics.StatisticsInfo.