Object documentation OPTIMIZERSTATISTICS Locate the document in its SAP Library structure

The statistics that are stored in the database catalog can be queried by selecting the system table OPTIMIZERSTATISTICS. Each row in the table describes statistics about indexes, columns, or the size of a table.

OPTIMIZERSTATISTICS

OWNER

CHAR(32)

Owner of a table for which statistics exist

TABLENAME

CHAR(32)

Table name of a table for which statistics exist

INDEXNAME

CHAR(32)

Index 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 Structure linkNULL

AVGLISTLENGTH

FIXED(10)

Average number of keys for an inversion list if the current row describes an index;
otherwise NULL

See also:

Structure linkUPDATE STATISTICS Statement (update_statistics_statement)