17.00 - IndexStatsV[X] - 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 alias 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 records Database version statistics collected on.
DBSVersion VARCHAR(32) LATIN UPPERCASE X(32) The ValidStats column indicates whether the statistics are valid or not.
IndexNumber SMALLINT ---,--9 Returns an internal number assigned to the index. A primary index has an index number of 1.
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.
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.