# 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 |