Scalable Database Server, HiRDB Version 8 Command Reference
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
|
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.