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