HELP STATISTICS Syntax Elements (QCD Form) - Teradata VantageCloud Lake
Lake - Working with SQL
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-21
- dita:mapPath
- jbe1714339405530.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- jbe1714339405530
- 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 or join 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.