17.10 - ExpStatsV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

Category: Optimizer Statistics

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The DatabaseName column is the name of the database in which the table resides.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The TableName column is the name of the containing table.
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 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.
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.