OPTIMIZERSTATISTICS

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