Figure 4-31 Information about Join operations 4.6.15 New MQT record types Enhancements have been added to the Database Monitor data to indicate usage of materialized query tables (MQT). Note: The query optimizer support for recognizing and using MQTs is available with V5R3 i5/OS PTF SI17164 and DB group PTF SF99503 level 4. Although an MQT can contain almost any query, the optimizer only supports a limited set of query functions when matching MQTs to user-specified queries. The user-specified query and the MQT must both use the SQE. The optimizer only uses one MQT per query. 1000/3006 Record: QQC22 has a new reason code of B5, which indicates that the access plan needed to be rebuilt because the MQT was no longer eligible to be used. The reasons might be that: ­ The MQT no longer exists