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. |