Category: Optimizer Statistics
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the database in which the table resides. |
| TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Name of the containing table. |
| ColumnName | VARCHAR(10000) UNICODE NOT CASESPECIFIC | X(10000) | Identifies a column or columns. |
| StatsName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name associated with the statistic. |
| StatsSource | CHAR(1) LATIN UPPERCASE | X(1) | Records the method this statistic is acquired. |
| ValidStats | CHAR(1) LATIN UPPERCASE | X(1) | Indicates whether the statistics are valid or not. |
| DBSVersion | VARCHAR(32) LATIN UPPERCASE | X(32) | Records the database version the statistics were collected on. |
| IndexNumber | SMALLINT | ---,--9 | 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. |
| StatsSkipCount | INTEGER | --,---,---,--9 | Number of times statistics collection on ExpressionList has been skipped. |
| 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. |
| BLCCompRatio | INTEGER | --,---,---,--9 | The estimated space savings percentage for primary subtable of manually compressed BLC tables. |
| AvgRowSize | FLOAT | ----,---,---,---,--9 | 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). |