HELP STATISTICS Syntax Elements (QCD Form) - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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.