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 joinQQJNTY Join type - when available IN - Inner join
PO - Left partial outer join
EX - Exception joinQQJNOP 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 productQQDSS Dataspace selection Y - Yes
N - NoQQIDXA Index advised Y - Yes
N - NoQQRCOD 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