Articles & Content


Materialized Query Tables - Deep Dive (C02)

Topic: DB2 for LUW

Subtopic: 2009

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

Click Here to Download

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