17.00 - ColumnStatsV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Optimizer Statistics

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the database name of the table, column, group of columns, index, view, or query on which statistics were collected.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the table that contains the column, group of columns, or index on which the statistics were collected.
ColumnName VARCHAR(10000) UNICODE NOT CASESPECIFIC X(10000) The ColumnName column identifies a column or columns.
StatsName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The StatsName column contains the name associated with the statistic
StatsSource CHAR(1) LATIN UPPERCASE X(1) The StatsSource column records the method this statistic is acquired.
ValidStats CHAR(1) LATIN UPPERCASE X(1) The ValidStats column indicates whether the statistics are valid or not.
DBSVersion VARCHAR(32) LATIN UPPERCASE X(32) Returns the version of the database that contains the objects on which the statistics were collected.
IndexNumber SMALLINT ---,--9 The IndexNumber column is the Index number of the index on which statistics are collected.
SampleSignature VARCHAR(256) LATIN NOT CASESPECIFIC X(256) The SampleSignature column is the Sample options encoded as a 10 character signature.
SampleSizePct DECIMAL(5,2) ----.99 The SampleSizePct column is the Sample size percent used when collecting statistics.
ThresholdSignature VARCHAR(512) LATIN NOT CASESPECIFIC X(512) The ThresholdSignature column is the Threshold options encoded as a 17 character signature.
MaxIntervals SMALLINT ---,--9 The MaxIntervals column is the User-specified maximum number of intervals.
MaxValueLength INTEGER --,---,---,--9 The MaxValueLength column is the User-specified maximum value length.
RowCount FLOAT ----,---,---,---,--9 The RowCount column is the row count of the table, view or query on which statistics are collected.
UniqueValueCount FLOAT ----,---,---,---,--9 The UniqueValueCount column is the Number of unique values of the ExpressionList.
PNullUniqueValueCount FLOAT ----,---,---,---,--9 The PNullUniqueValueCount column is the Number of unique values from rows with partial nulls.
NullCount FLOAT ----,---,---,---,--9 The NullCount column is the Number of nulls of the ExpressionList.
AllNullCount FLOAT ----,---,---,---,--9 The AllNullCount column is the Number of all nulls of the ExpressionList.
HighModeFreq FLOAT ----,---,---,---,--9 The HighModeFreq column is the highest frequency of values of the ExpressionList.
PNullHighModeFreq FLOAT ----,---,---,---,--9 The PNullHighModeFreq column is the highest frequency of values having partial nulls of the ExpressionList.
StatsSkipCount INTEGER --,---,---,--9 The StatsSkipCount column indicates how many times the statistics collection on the ExpressionList has been skipped.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS The CreateTimeStamp column is the statistics creation time stamp.
LastCollectTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS The LastCollectTimeStamp column is the Last statistics collection time stamp.
LastAlterTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS The LastAlterTimeStamp column is the last user updated time stamp.