Information about the index scan being
performed
ID Name Type
Description
2110
QQKP
CHAR(1) Index Scan -
Key Positioning.
Y - Yes
N - No
2112
QQKPN
BIN(32) Number of
columns using key positioning.
2114 QQFKEY
BIN(32) Estimated
number of entries selected using
key positioning.
2116 QQKS
CHAR(1) Index Scan -
Key Selection.
Y - Yes
N - No
2118
QQKSEL
BIN(32) Estimated
number of entries selected using
key selection.
2122 QVKOA
BIN(32) Index only
access.
Y - Yes
N - No
2124
QVIDXM
BIN(32) Index fits
in memory.
Y - Yes
N - No
2126
QVIDXSK
BIN(32) Index skip
key processing.
Y - Yes
N - No
2140
QVIDXTY
BIN(32) Type of
index. Possible values are:
B - Binary Radix
C - Constraint (binary radix)
E - Encoded Vector Index (EVI)
T - Query created temporary index
2142 QVIDXN
BIN(32) Number of
index entries.
2144 QVIDXUQ
BIN(32) Number of
unique index values.
2146 QVIDXPO
BIN(32) Percent
overflow for EVI.
2148 QVIDXVZ
BIN(32) Vector size
of index for EVI.
2150 QVIDXSZ
BIN(32) Size, in
bytes, of index.
2152 QVIDXPZ
BIN(32) Page size,
in bytes, of index.