The system table <DATABASE_SYSTEM_ADMINISTRATOR>.OPTIMIZERSTATISTICS contains stored statistics in the database catalog.
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
OWNER |
CHAR(32) |
Name of the owner of a table for which statistics exist |
TABLENAME |
CHAR(32) |
Name of a table for which statistics exist |
INDEXNAME |
CHAR(32) |
Name of an index for which statistics exist |
COLUMNNAME |
CHAR(32) |
Name of a column for which statistics exist |
DISTINCTVALUES |
FIXED(10) |
Number of different values if the current row describes a column or an index with one column; otherwise the number of rows in a table |
PAGECOUNT |
FIXED(10) |
Number of pages used by an index if the current row describes an index; number of pages of a base table if the current row describes a table; otherwise NULL |
PARTITIONID |
FIXED(5) |
Identification of the partition, NULL if table is not partitioned |
Database Administration, SQL Optimizer Statistics
SQL Reference Manual, UPDATE STATISTICS Statement