External table description (QAQQ3030) - Materialized query table implementation

 

Table 1. QQQ3030 - Materialized query table implementation
Column Name Description
QQKEY Join column (unique per query) used to link rows for a single query together
QQTIME Time row was created
QQQDTN Unique subselect number
QQQDTL Subselect nested level
QQMATN Materialized view subselect number
QQMATL Materialized view nested level
QQMRSN List of unique reason codes used by the materialized query table (each materialized query table has a corresponding reason code associated with it)
QQMQTS List of MQTs examined with a reason code indicating if the MQT was used and if not used, why not used.
QQC11 Reserved
QQC12 Reserved
QQC21 Reserved
QQC22 Reserved
QQCI1 Reserved
QQCI2 Reserved
QQC301 Reserved
QQC302 Reserved

 

Parent topic:

Memory Resident Database Monitor: DDS