Materialized Query Tables - Deep Dive

Date: 
Wednesday, 14 June, 2017 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
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. 

 

sqladria

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

facebook
linkid
twitter

 

Events in 2020

Ljubljana - 
Belgrade - 
Šibenik - 4th - 8th October 2020
Zagreb - 25th September 2020
Opatija - 26th & 27th November 2020