16.4.2 Specifications in the optimization information parameter file

The table below describes how to specify the items in the optimization information parameter file, and Table 16-9 Specification of MAX_VALUE and MIN_VALUE describes how to specify MAX_VALUE and MIN_VALUE. Table 16-10 Default values for items in the optimization information parameter file lists the default values for items in the optimization information parameter file.

Table 16-8 Specifications in the optimization information parameter file

ItemSpecificationPermitted minimum valuePermitted maximum valueUnits
NROWSSpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBRows
NPAGES0Pages
INDEXComply with the rules for index definition.
NIPAGESSpecify a positive integer. An exponential value can also be specified.1Maximum FLOAT value supported by HiRDBPages
NLEVELSpecify a positive integer.1Maximum SMALLINT value supported by HiRDBColumns
SEQ_RATIO0100%
NENTRYSpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBValues
COLUMNComply with the rules for table definition.
NUNIQUESpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBValues
NNULLS0Values
N_MAX_DUP_KEY0Values
N_MIN_DUP_KEY0Values
MAX_VALUE--
MIN_VALUE
SECTION_COUNTSpecify a positive integer. An exponential value can also be specified.0100Sections
SECTION_NO1Number of sections--
SEC_TOTAL_COUNT1Maximum value for the SMALLFLT type in HiRDBRows
SEC_UNIQUE1Maximum value for the SMALLFLT type in HiRDBValues
SEC_MAX_VALUE--

--: Not applicable.

Table 16-9 Specification of MAX_VALUE and MIN_VALUE

Data type of column specified for COLUMNSpecificationMaximum and minimum values
INT[EGER]Specify a numeric value.HiRDB rules for each data type are observed. The permitted maximum number of digits complies with the HiRDB rules for numeric literals. For details, see Data types in the manual HiRDB Version 9 SQL Reference.
SMALLINT
[LARGE]DEC[IMAL]
FLOAT or DOUBLE PRECISIONSpecify a numeric value. An exponential value can also be specified.
SMALLFLT or REAL
CHARSpecify a character or a character string.
If the data type is CHAR, VARCHAR, MCHAR, or MVARCHAR and the data contains a control character, such as \0 or a linefeed code, or a character set is specified for the column, specify the character string in hexadecimal characters.#2
You must enclose the character string in double quotation marks (") if any of the following applies:
  • The character string contains a space.
  • The length of the character string is 0.
  • The character string begins with x' or X' and ends with '.
One line of character string data including the item name can be specified in the optimization information parameter file. The utility registers the first 16 bytes as the optimization information (not including double quotation marks) and discards any remaining characters.
If the data type is MCHAR or MVARCHAR and byte 16 or 17 contains a 2-byte code, at least 17 bytes of character string data must be specified.
VARCHAR
NCHAR
NVARCHAR
MCHAR
MVARCHAR
DATESpecify in the format YYYY-MM-DD.HiRDB rules for each data type are observed. For details, see Data types in the manual HiRDB Version 9 SQL Reference.
TIMESpecify in the format hh:mm:ss.
INTERVAL YEAR TO DAYSpecify in the format ([Figure])YYYYMMDD.
INTERVAL HOUR TO SECONDSpecify in the format ([Figure])hhmmss.
TIMESTAMP"YYYY-MM-DD[Figure]hh:mm:ss[.nnnnnn]"
[Figure]: Single-byte space
For the fraction part [.nnnnnn], specify 0, 2, 4, or 6 according to the definition.#1 Enclose the specified value in double quotation marks.
BINARYSpecify binary data expressed as hexadecimal characters.#2 For data with a length of 0, specify X''.The utility registers the first 12 bytes as the optimization information and discards any remaining characters.
#1: The following table describes the storage method when the decimal places are specified for the second part of the TIMESTAMP type:
Defined lengthDecimal places in the second part of input data
0246Other
0Stored as isTruncated at the defined lengthError (KFPL31002-E)
2Zeros are padded up to the defined lengthStored as isTruncated at the defined length
4Zeros are padded up to the defined lengthStored as isTruncated at the defined length
6Zeros are padded up to the defined lengthStored as is
#2: Hexadecimal representation is x'****' or X'****'. For ****, specify a hexadecimal value in units of two characters (0-9, a-f, and A-F).

Table 16-10 Default values for items in the optimization information parameter file

ItemValueName of target dictionary tableName of target columnSet valueRows subject to setting in target dictionary table
NROWS#1SpecifiedSpecifiedSQL_TABLE_STATISTICSN_ROWValue specified for NROWSTable specified with -t option
Not specifiedNull value
Not specified--Value existing before update
NPAGESSpecifiedSpecifiedN_PAGEValue specified for NPAGES
Not specifiedNull value
Not specified--Value existing before update
NIPAGESSpecifiedSpecifiedSQL_INDEX_STATISTICSN_IXPGValue specified for NIPAGESIndex specified with INDEX
Not specifiedNull value
Not specified--Value existing before update
NLEVELSpecifiedSpecifiedN_LEVELValue specified for NLEVEL
Not specifiedNull value
Not specified--Value existing before update
SEQ_RATIOSpecifiedSpecifiedSEQ_RATIOValue specified for SEQ_RATIO
Not specifiedNull value
Not specified--Value existing before update
NENTRYSpecifiedSpecifiedN_ENTRYValue specified for N_ENTRY
Not specifiedNull value
Not specified--Value existing before update
NUNIQUESpecifiedSpecifiedSQL_COLUMN_STATISTICSN_UNIQUEValue specified for NUNIQUEColumn specified with COLUMN
Not specifiedNull value
Not specified--Value existing before update
NNULLS#1SpecifiedSpecifiedN_NULLValue specified for NNULLS
Not specifiedNull value
Not specified--Value existing before update
N_MAX_DUP_KEYSpecifiedSpecifiedN_MAX_DUP_KEYValue specified for N_MAX_DUP_KEY
Not specifiedNull value
Not specified--Value existing before update
N_MIN_DUP_KEYSpecifiedSpecifiedN_MIN_DUP_KEYValue specified for N_MIN_DUP_ KEY
Not specifiedNull value
Not specified--Value existing before update
MAX_VALUE#1SpecifiedSpecifiedRANGE_VALUESValue specified for MAX_VALUE
Not specifiedNull value
Not specified--Null value
MIN_VALUE#1SpecifiedSpecifiedValue specified for MIN_VALUE
Not specifiedNull value
Not specified--Null value
SECTION_COUNTSpecifiedSpecifiedValue specified in SECTION_COUNT#2
Not specified0
Not specified--0
SECTION_NOSpecifiedSpecifiedValue specified in SECTION_NO
Not specifiedError
Not specified--Error
SEC_TOTAL_COUNTSpecifiedSpecifiedValue specified in SEC_TOTAL_COUNT
Not specifiedError
Not specified--Error
SEC_UNIQUESpecifiedSpecifiedValue specified in SEC_UNIQUE
Not specifiedError
Not specified--Error
SEC_MAX_VALUESpecifiedSpecifiedValue specified in SEC_MAX_VALUE
Not specifiedError
Not specified--Error

--: Not applicable.

#1
If NROWS, NNULLS, MAX_VALUE, or MIN_VALUE is omitted, the null value is set in the RANGE_VALUES column in SQL_COLUMN_STATISTICS.
#2
If the number of sections (SECTION_COUNT) and the items for section distribution information are all omitted, 0 is set. If any of the section distribution information items is omitted for any of the sections, an error results.