Articles & Content

Archives

Let’s Look at Materialized Query Tables for DB2 UDB V8 (F12)

Topic: DB2 for z/OS

Subtopic: 2005



DATE: 2005-5-25 (12:30 PM - 01:40 PM)
SPEAKERS: Randy Ebersole (IBM Silicon Valley Lab)

It is very common that as the amount of data grows in DB2 UDB tables and as applications become more complex, queries must run against a large amount of data. Materialized Query Tables provide an effective approach in providing query results against large amounts of data. This presentation will discuss the basics of Materialized Query Tables and give you an understanding of how you can best utilize this new functionality.

EXP. LEVEL: Beginner

OBJECTIVES:

MQT - The Basics

MQT - How to define

MQT - How to exploit

MQT - Examples of use

MQT - Performance Results



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.