Articles & Content


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

Topic: 2005 NA

Subtopic: DB2 for z/OS

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


MQT - The Basics

MQT - How to define

MQT - How to exploit

MQT - Examples of use

MQT - Performance Results

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.