16.4.3 Items output to the optimization information parameter file

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

ClassificationItemData dictionary table and column to be referencedItem that is output
Table nameColumn nameNo corresponding columnValue in referenced column is null valueValue in referenced column is non-null value
Table optimization informationNROWSSQL_TABLE_STATISTICSN_ROWNIY
NPAGESN_PAGENIY
Index optimization informationINDEXSQL_INDEX_STATISTICSINDEX_NAMEN--Y#1
NIPAGESN_IXPGNIY
NLEVELN_LEVELNIY
SEQ_RATIOSEQ_RATIONIY
NENTRYN_ENTRYNIY
Column optimization informationCOLUMNSQL_COLUMN_STATISTICSCOLUMN_NAMEN--Y#1
NUNIQUEN_UNIQUENIY
NNULLSN_NULLNIY
N_MAX_DUP_KEYN_MAX_DUP_KEYNIY
N_MIN_DUP_KEYN_MIN_DUP_KEYNIY
MAX_VALUERANGE_VALUESNNY#2
MIN_VALUENNY#2
Section distribution informationSECTION_COUNTNNY
SECTION_NONNY
SEC_TOTAL_COUNTNNY
SEC_UNIQUENNY
SEC_MAX_VALUENNY#2
Legend:
Y: Name of item and column value are both output.
I: Only name of item is output.
N: Not output
--: Not applicable
#1
Enclosed in double quotation marks (")
#2
For details about the output value, see Table 16-3 Information collected or registered as key value distribution information for index component columns. If the data type is CHAR, NCHAR, MCHAR, VARCHAR, NVARCHAR, or MVARCHAR, the item is output in hexadecimal for the upper-case letters. The hexadecimal format is X'****', where **** indicates hexadecimal characters (0 to 9, A to F) in units of two characters.