Category: Optimizer Statistics
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | 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) | 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) | Identifies a column or columns. |
| StatsName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Contains the alias name associated with the statistic |
| StatsSource | CHAR(1) LATIN UPPERCASE | X(1) | The method this statistic is acquired. |
| ValidStats | CHAR(1) LATIN UPPERCASE | X(1) | Records the database version the statistics were collected on. |
| DBSVersion | VARCHAR(32) LATIN UPPERCASE | X(32) | The version of the database that contains the objects on which the statistics were collected. |
| IndexNumber | SMALLINT | ---,--9 | The Index number of the index on which statistics are collected. |
| SampleSignature | VARCHAR(256) LATIN NOT CASESPECIFIC | X(256) | The sample options encoded as a 10 character signature. |
| SampleSizePct | DECIMAL(5,2) | ----.99 | The sample size percent used when collecting statistics. |
| ThresholdSignature | VARCHAR(512) LATIN NOT CASESPECIFIC | X(512) | The threshold options encoded as a 17 character signature. |
| MaxIntervals | SMALLINT | ---,--9 | The user-specified maximum number of intervals. |
| MaxValueLength | INTEGER | --,---,---,--9 | The user-specified maximum value length. |
| RowCount | FLOAT | ----,---,---,---,--9 | The row count of the table, view or query on which statistics are collected. |
| UniqueValueCount | FLOAT | ----,---,---,---,--9 | Number of unique values of the ExpressionList. |
| PNullUniqueValueCount | FLOAT | ----,---,---,---,--9 | Number of unique values from rows with partial nulls. |
| NullCount | FLOAT | ----,---,---,---,--9 | Number of nulls of the ExpressionList. |
| AllNullCount | FLOAT | ----,---,---,---,--9 | Number of all nulls of the ExpressionList. |
| HighModeFreq | FLOAT | ----,---,---,---,--9 | The highest frequency of values of the ExpressionList. |
| PNullHighModeFreq | FLOAT | ----,---,---,---,--9 | The highest frequency of values having partial nulls of the ExpressionList. |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The statistics creation timestamp. |
| LastCollectTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The last statistics collection timestamp. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The last user updated timestamp. |