# Table optimization information
NROWS 100 # Total number of rows in table
NPAGES 5 # Number of data pages in table
# Index optimization information
INDEX IDX_I01 # Index name
NIPAGES 2 # Number of index pages
NLEVEL 2 # Number of index levels
SEQ_RATIO 80 # Degree of sequentiality of index
NENTRY 50 # Number of index key values
# Column optimization information
COLUMN COL_01 # Column name
NUNIQUE 50 # Number of unique values in column
NNULLS 2 # Number of null values in column
N_MAX_DUP_KEY 5 # Maximum number of duplicate column
values
N_MIN_DUP_KEY 1 # Minimum number of duplicate column
values
MAX_VALUE ZZZ # Maximum column value
MIN_VALUE ABC # Minimum column value
# Section distribution information
SECTION_COUNT 2 # Number of sections
SECTION_NO 1 # Section number
SEC_TOTAL_COUNT 1 # Cumulative frequency of the number of elements for the section
SEC_UNIQUE 1 # Number of unique values in section
SEC_MAX_VALUE ABC # Maximum value in section
SECTION_NO 2
SEC_TOTAL_COUNT 2
SEC_UNIQUE 1
SEC_MAX_VALUE DEF |