The OPTIMIZERINFORMATION system table contains the information about value distributions that is determined by the UPDATE STATISTICS statement and used by the SQL optimizer.
OPTIMIZERINFORMATION
CHAR(32) |
Name of the schema of the table |
|
TABLENAME |
CHAR(32) |
Name of the table |
COLUMNNAME |
CHAR(32) |
Name of a single, non-indexed column |
INDEXNAME |
CHAR(32) |
Name of index |
DISTINCTVALUECOUNT |
FIXED(10) |
Number of distinct values in column, index, or primary key |
CALCULATEDSIZE |
FIXED(10) |
Memory requirements of (primary key) index calculated by last UPDATE STATISTICS (KB) |