External table description (QAQQ3000) - Arrival sequence

 

Table 1. QAQQ3000 - Arrival sequence
Column Name Description
QQKEY Join column (unique per query) used to link rows for a single query together with row identification
QQTIME Time row was created
QQQDTN QDT number (unique per ODT)
QQQDTL QDT subquery nested level
QQMATN Materialized view QDT number
QQMATL Materialized view nested level
QQTLN Library
QQTFN Table
QQPTLN Physical library
QQPTFN Physical table
QQTOTR Total rows in table
QQREST Estimated number of rows selected
QQAJN Estimated number of joined rows
QQEPT Estimated processing time, in seconds
QQJNP Join position - when available
QQJNDS Dataspace number
QQJNMT Join method - when available

NL - Nested loop
MF - Nested loop with selection
HJ - Hash join

QQJNTY Join type - when available

IN - Inner join
PO - Left partial outer join
EX - Exception join

QQJNOP Join operator - when available

EQ - Equal
NE - Not equal
GT - Greater than
GE - Greater than or equal
LT - Less than
LE - Less than or equal
CP - Cartesian product

QQDSS Dataspace selection

Y - Yes
N - No

QQIDXA Index advised

Y - Yes
N - No

QQRCOD Reason code

T1 - No indexes exist.
T2 - Indexes exist, but none can be used.
T3 - Optimizer chose table scan over available indexes.

QQLTLN Library-long
QQLTFN Table-long
QQLPTL Physical library-long
QQLPTF Table-long
QQIDXD Key columns for the index advised
QQC11 Materialized query table
QQC12 Reserved
QQC21 Reserved
QQC22 Reserved
QQI1 Number of advised key columns that use index scan-key positioning.
QQI2 Reserved
QQC301 Reserved
QQC302 Reserved
QQ1000 Reserved

 

Parent topic:

Memory Resident Database Monitor: DDS