Articles & Content

Archives

Materialized Query Tables - Deep Dive (C02)

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

OBJECTIVES:

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.