Optimizer timed out information
ID Name Type
Description
2320
QQTOUT
CHAR(1) Indicates if
the query optimizer timed
out and did not consider all available
indexes.
Y - Yes
N - No
2322
QVTOUTR
BIN(32) Reason code
why the index was not used.
Possible values are:
1 - System invalidated the index.
2 - User requested the index be rebuilt.
3 - Index is a temporary index and is
not the table being queried.
4 - Cost to use this index, as determined
by query optimizer, was too high.
5 - Key columns of index did not match
columns specified for ordering or grouping.
6 - Key columns of index did not match
columns specified for join criteria.
7 - Use of this index would not minimize
I/O at run time, as user requested.
8 - Index cannot be used for a secondary
file of the join query.
9 - Table queried contains record ID
selection which forces a temporary
index to be used for the join query.
10 - User specified . ignore decimal data
errors. on the query which disallows
use of permanent indexes.
11 - Index contains select or omit criteria
which does not match selection criteria
in the query.
12 - Index contains select or omit criteria
whose compatibility with the selection
in the query could not be determined.
13 - Index contains one or more keys which
may be changed by the query during an
insert or update.
14 - Index is being deleted or created in an
uncommited unit or work by another job.
15 - The sequence table associated with the
index did not match the sequence table
associated with the query.
16 - The sequence table associated with the
index did not match the sequence table
associated with the query.
17 - Index scan - key positioning could not
be used for this index because the
left-most key of the index did not
match any column used in the query
selection.
18 - Index scan - key positioning could not
be used for this index because the
NLSS table associated with the index
did not match the NLSS table associated
with the query.
2324 QQIDXN
VARCHAR(1000) List of the indexes the query
optimizer
did consider.