The table below lists the names of the data dictionary tables and columns that are referenced for the items in the optimization information parameter file and the items that are output.
Table 16-11 Items in the optimization information parameter file and the items that are output
Classification | Item | Data dictionary table and column to be referenced | Item that is output | |||
---|---|---|---|---|---|---|
Table name | Column name | No corresponding column | Value in referenced column is null value | Value in referenced column is non-null value | ||
Table optimization information | NROWS | SQL_TABLE_STATISTICS | N_ROW | N | I | Y |
NPAGES | N_PAGE | N | I | Y | ||
Index optimization information | INDEX | SQL_INDEX_STATISTICS | INDEX_NAME | N | -- | Y#1 |
NIPAGES | N_IXPG | N | I | Y | ||
NLEVEL | N_LEVEL | N | I | Y | ||
SEQ_RATIO | SEQ_RATIO | N | I | Y | ||
NENTRY | N_ENTRY | N | I | Y | ||
Column optimization information | COLUMN | SQL_COLUMN_STATISTICS | COLUMN_NAME | N | -- | Y#1 |
NUNIQUE | N_UNIQUE | N | I | Y | ||
NNULLS | N_NULL | N | I | Y | ||
N_MAX_DUP_KEY | N_MAX_DUP_KEY | N | I | Y | ||
N_MIN_DUP_KEY | N_MIN_DUP_KEY | N | I | Y | ||
MAX_VALUE | RANGE_VALUES | N | N | Y#2 | ||
MIN_VALUE | N | N | Y#2 | |||
Section distribution information | SECTION_COUNT | N | N | Y | ||
SECTION_NO | N | N | Y | |||
SEC_TOTAL_COUNT | N | N | Y | |||
SEC_UNIQUE | N | N | Y | |||
SEC_MAX_VALUE | N | N | Y#2 |