External table description (QAQQ3003) - Query sort
Table 1. QQQ3003 - Query sort 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 QQTTIM Sort time QQRSS Number of rows selected or sorted QQSIZ Size of sort space QQPSIZ Pool size QQPID Pool id QQIBUF Internal sort buffer length QQEBUF External sort buffer length QQRCOD Reason code
- F1 - Query contains grouping columns (Group By) from more than one table, or contains grouping columns from a secondary table of a join query that cannot be reordered.
- F2 - Query contains ordering columns (Order By) from more than one table, or contains ordering columns from a secondary table of a join query that cannot be reordered.
- F3 - The grouping and ordering columns are not compatible.
- F4 - DISTINCT was specified for the query.
- F5 - UNION was specified for the query.
- F6 - Query had to be implemented using a sort. Key length of more than 2000 bytes or more than 120 columns specified for ordering.
- F7 - Query optimizer chose to use a sort rather than an index to order the results of the query.
- F8 - Perform specified row selection to minimize I/O wait time.
- FC - The query contains grouping fields and there is a read trigger on at least one of the physical files in the query.
QQC11 Reserved QQC12 Reserved QQC21 Reserved QQC22 Reserved QQI1 Reserved QQI2 Reserved QQC301 Reserved QQC302 Reserved QQ1000 Reserved
Parent topic:
Memory Resident Database Monitor: DDS