16.4.3 Specification example of the optimization information parameter file

Following is a specification example of an optimization information parameter file:

# 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