OPTIMIZERSTATISTICS

Definition

The system table OPTIMIZERSTATISTICS can be used to query statistical values that were generated by an UPDATE STATISTICS statement and are stored in the database catalog. Each row of the table describes statistical values of indexes, columns or the size of a table.

Structure

OPTIMIZERSTATISTICS

SCHEMANAME

CHAR(32)

Name of the schema of the table for which statistical information is available

OWNER

CHAR(32)

Name of the owner of the table for which statistical information is available

TABLENAME

CHAR(32)

Name of the table for which statistical information is available

INDEXNAME

CHAR(32)

Name of the index for which statistical information is available

COLUMNNAME

CHAR(32)

Name of a column for which statistical information is available

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 value

The system table OPTIMIZERSTATISTICS exists only to enable compatibility with older database versions. Instead of the system table OPTIMIZERSTATISTICS, use the system table OPTIMIZERINFORMATION.