Implementation summary for the SQL statement
executed
ID Name Type
Description
7010 QVOBYIM
CHAR(1) Ordering
implementation. Possible values:
I - Index
S - Sort
7011 QVORIXN
CHAR(10) Name of index
used for ordering.
7012 QVORIXL
CHAR(10) Library of index
used for ordering.
7013 QVORIXNL
VARCHAR(128) Long name of index used for
ordering.
7014 QVORIXLL
VARCHAR(128) Long schema of index used for
ordering.
7020 QVGBYIM
CHAR(1) Grouping
implementation. Possible values:
I - Index
H - Hash
7021 QVGPIXN
CHAR(10) Name of index
used for grouping.
7022 QVGPIXL
CHAR(10) Library of index
used for grouping.
7023 QVGPIXNL
VARCHAR(128) Long name of index used for
grouping.
7024 QVGPIXLL
VARCHAR(128) Long schema of index used for
grouping.
7030 QVJONIM
CHAR(1) Join
implementation. Possible values:
N - Nested Loop join
H - Hash join
C - Combination of Nested Loop and Hash
7032
QVDIST
CHAR(1) Distinct
query.
Y - Yes
N - No
7034
QVDSTRB
CHAR(1) Distributed
query.
Y - Yes
N - No
7036
QVDSTND VARCHAR(300)
Distributed nodes for distributed query.
7050 QVIMPLN
VARCHAR(300) Quick peek of the query
implementation.