Articles & Content

Archives

Experiences with the Design Advisor (D04)

Topic: 2005 NA

Subtopic: DB2 for LUW



DATE: 2005-05-23 (03:30 PM - 04:40 PM)
SPEAKERS: Martin Hubel (Martin Hubel Consulting, Inc.)

The Index Advisor was introduced in DB2 V6 as a component of DB2. Now renamed to the Design Advisor in DB2 v8.2, it has been enhanced to provide supprt for MDCs, MQTs and partitioning. This presentation shows how the Design Advisor should be a valuable part of every DBA’s toolkit. The presenter will share his experience from several customer locations including OLTP and data warehousing applications.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Overview

Index tuning

MDC uses

MQT uses

Recommendations for use



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.