Nonstop Database, HiRDB Version 9 Command Reference
16.4.5 Specification rules for the optimization information parameter file
- Begin the name of each item in byte 1and complete each item on one line.
- Separate an item name and its value with a blank (two-byte blank) or a tab.
- No more than one item can be specified on each line. One line consists of 80 bytes (not including linefeed code).
- Anything between the hash mark (#) and the linefeed code is regarded as a comment.
- Except for the section distribution information, the same item cannot be specified more than once in the table, index, or column optimization information.
- A value must be enclosed in double quotation marks (") if any of the following applies:
The specified value contains a space.
A character string with a length of 0 is specified.
A character string beginning with x' or X' and ending with ' is specified.
A case-sensitive index name or column name is specified.
If the specified index name or column name is not enclosed in double quotation marks ("), all single-byte lower-case letters are treated as single-byte upper-case letters.
If a specified value contains a backslash (\), the data immediately following \ is used. To use \ as part of the data, two consecutive backslashes in succession must be specified.
- Items can be specified in any order within a range of index or column optimization information. A range of index or column optimization information begins with an index name or column name and ends when another index name or column name appears.
Note that in the definition of optimization information, the number of sections must be specified before the section distribution information. Also, you must specify the section number at the beginning of each section definition in the section distribution information.
- If the same index name or column name is specified more than once, the last one specified is effective.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.