Articles & Content
Topic: 2009 EU
Subtopic: DB2 for LUW
DATE: 2009-10-5 (13:30 - 14:30)
SPEAKERS: Melanie Stopfer (IBM Software Group)
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 pre-computed results. Learn how to deploy MQTs. Through examples, learn steps necessary to create, maintain and use MQTs. Get the details on MQT locking and logging considerations. MQT maintenance and trade-offs associated with various approaches will be analyzed. Learn the top tips to improve MQT matching, which is the process DB2 uses to transparently answer queries against base tables using pre-computed query results stored in MQTs. Advanced uses and the benefits of MQTs with advanced query optimization techniques will be discussed.
EXP. LEVEL: Intermediate,Advanced
Create and populate a MQT
Explain MQT routing, locking and logging considerations
Implement MQT maintenance modes of deferred, immediate and refresh deferred with a staging table
Perform incremental maintenance of MQT after load append
Analyze the benefits of advanced uses of MQTs in DB2 and implement top tips to improve MQT matching
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.