The utility might not acquire optimization information for the index and the columns composing the index depending on the conditions. If optimization information is not acquired, it cannot be registered using the optimization information parameter file. The following describes the conditions under which optimization information is not acquired.
- Conditions under which optimization information is not acquired for columns composing an index
- The column structure is a column composing the index# and the data type is an abstract data type.
- The column structure is a column composing the index,# the data type is not an abstract data type, but there is a repetition column.
- The column structure is not a column composing the index.
- #: In the case of a multicolumn index, this is the first column comprising the multicolumn index.
- Conditions under which optimization information is not acquired for an index
- B-tree index whose first column composing the index is a repetition column
- Substructure index#
- Plug-in index#
- #: If an attempt is made to register optimization information using the optimization information parameter file, the utility outputs the KFPN00201-E message and terminates with an error.