External table description (QAQQ3002) - Index created

 

Table 1. QQQ3002 - Index created

Column Name	Description
QQKEY	Join column (unique per query) used to link rows for a single query together
QQTIME	Time row was created
QQQDTN	QDT number (unique per QDT)
QQQDTL	RQDT subquery nested level relational database name
QQMATN	Materialized view QDT number
QQMATL	Materialized view nested level
QQTLN	Library
QQTFN	Table
QQPTLN	Physical library
QQPTFN	Physical table
QQILNM	Index library
QQIFNM	Index
QQNTNM	NLSS table
QQNLNM	NLSS library
QQTOTR	Total rows in table
QQRIDX	Number of entries in index created
QQREST	Estimated number of rows selected
QQFKEY	Number of index scan-key positioning keys
QQKSEL	Number of index scan-key selection keys
QQAJN	Estimated number of joined rows
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
QQIDXK	Number of advised key columns that use index scan-key positioning
QQEPT	Estimated processing time, in seconds
QQKP	Index scan-key positioning Y - Yes N - No
QQKPN	Number of index scan-key positioning columns
QQKS	Index scan-key selection Y - Yes N - No
QQDSS	Dataspace selection Y - Yes N - No
QQIDXA	Index advised Y - Yes N - No
QQCST	Constraint indicator Y - Yes N - No
QQCSTN	Constraint name
QQRCOD	Reason code I1 - Row selection I2 - Ordering/Grouping I3 - Row selection and      Ordering/Grouping I4 - Nested loop join I5 - Row selection using       bitmap processing
QQTTIM	Index create time
QQLTLN	Library-long
QQLTFN	Table-long
QQLPTL	Physical library-long
QQLPTF	Table-long
QQLILN	Index library-long
QQLIFN	Index-long
QQLNTN	NLSS table-long
QQLNLN	NLSS library-long
QQIDXD	Key columns for the index advised
QQCRTK	Key columns for index created
QQC11	Materialized query table
QQC12	Reserved
QQC21	Reserved
QQC22	Reserved
QQI1	Reserved
QQI2	Reserved
QQC301	Reserved
QQC302	Reserved
QQ1000	Reserved

 

Parent topic:

Memory Resident Database Monitor: DDS