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

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.