17.00 - TableStatsV - 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) 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 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) The DBSVersion column records Database version statistics collected on.
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.
BLCCompRatio INTEGER --,---,---,--9 The estimated space savings percentage for primary subtable of manually compressed BLC tables.
AvgRowSize FLOAT ----,---,---,---,--9 The AvgRowSize column is the average row size of an object on which statistics are collected.
BLCCompFactor FLOAT ----,---,---,---,--9 The estimated block compression factor for the entire table. This is used for calculating the Customer Data Space (CDS).