Materialized Query Tables - Deep Dive

Wednesday, 14 June, 2017 - 11:30 - 12:30
LUW Track
Melanie Stopfer

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. 



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020