Estimated rows selected and query join
information
ID Name Type
Description
2042
QQREST
BIN(32) Estimated
number of rows to be retrieved.
2044 QQAJN
BIN(32) Estimated
number of joined rows to be
retrieved.
2046 QQJNP
BIN(32) Join
position of the table queried.
2048 QQJNDS
BIN(32) Table data
number of the table queried.
2050 QQJNMT
CHAR(2) Join method.
Possible options are:
NL - Nested loop
MF - Nested loop with selection
HJ - Hash join
2052 QQJNTY
CHAR(2) Join type.
Possible values are:
IN - Inner join
PO - Left partial outer join
EX - Exception join
2054 QQJNOP
CHAR(2) Join
operator. Possible values are:
EQ - Equal
NE - Not equal
GT - Greater than
GE - Greater than or equal
LT - Less than
LE - Less than or equal
CP - Cartesian product
2056 QVJFANO
CHAR(1) Type of join
fan-out. Possible values are:
N - Normal join situation where join fan-out
is allowed and each matching row of the
join fan-out is returned.
D - Distinct fan-out. Join fan-out is allowed;
however, none of the join fan-out rows
are returned.
U - Unique fan-out. Join fan-out is not allowed.
Error situation if join fan-out occurs.
2058 QVFILES
BIN(32) Number of
tables joined together.
2070 QVBNDY
CHAR(1) Indicates if
the query is I/O or CPU bound.
Possible values are:
I - I/O bound.
C - CPU bound.
2080 QQRCOD
CHAR(2) Reason code
for current operation.