Materialized Query Tables - Deep Dive

Materialized Query Tables (MQTs) are widely used to significantly speed up the response time of decision support queries. A MQT is a table whose definition is based on the result of a query and whose data is in the form of precomputed results. Learn how to deploy MQTs. Through examples, learn steps necessary to create, maintain and use MQTs. MQT maintenance and trade-offs associated with various approaches will be analyzed. Learn about MQT matching, which is the process DB2 uses to transparently answer queries against base tables using precomputed query results stored in MQTs. Advanced uses and the benefits of MQTs with advanced query optimization techniques will be discussed.