Question: what are mqt in db2?
Answer: A materialized query table (MQT) is a table whose definition is based upon the result of a query. ... Summary tables (or automatic summary tables, ASTs), which are familiar to IBM® DB2® Universal Database™ (UDB) for Linux, UNIX®, and Windows® (DB2 UDB) users, are considered to be a specialized type of MQT.