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

Following is an example of the output of an optimization information parameter file:

 
# STATISTICS INFORMATION FOR SQL OPTIMIZATION
# TABLE "USER1"."TBL1"
# TABLE INFORMATION
# "USER1"."TBL1"
NROWS            100          # Total number of rows in table
NPAGES           5            # Number of data pages in table
# INDEX 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 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        X'5A5A5A'    # Maximum column value
MIN_VALUE        X'414243'    # Minimum column value
## SECTION 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    X'414243'    # Maximum value in section
SECTION_NO       2
SEC_TOTAL_COUNT  2
SEC_UNIQUE       1
SEC_MAX_VALUE    X'444546'

16.4.4 Example of the optimization information parameter file

(1) Example coding

(2) Example output