KFAA96411-I
The index specification is disabled. (table name = "aa....aa"."bb....bb" as "cc....cc") (M+S)
The index specification for the table aa....aa.bb....bb (correlation name cc....cc) was ignored.
If a nonexistent index name or an invalid index name was specified in the index specification, that index specification is ignored. Check the index name specified in the index specification.
The following is a possible reason why the index specified in the index specification cannot be used:
-
If the specified index is a B-tree index
A B-tree index with null-value exclusion specification was specified and the index search range contains a null value.
-
If the specified index is a text index
The index specified by the index specification cannot be used when HADB cannot use the text index efficiently because, for example, the LIKE predicate that can be evaluated by the text index is not specified.
- aa....aa:
-
Schema name
- bb....bb:
-
Table identifier
- cc....cc: Correlation name
-
If no correlation name has been specified, *** is displayed.
- S:
-
Continues processing.