Articles & Content


More Experiences with the Design Advisor (Part 2 of 2) (D13)

Topic: DB2 for LUW

Subtopic: 2006

DATE: 2006-10-4 (17:30 - 18:30)
SPEAKERS: Martin Hubel (Martin Hubel Consulting, Inc.)

The Index Advisor was introduced in DB2 V6. Now renamed to the Design Advisor in DB2 v8.2, this component of DB2 is enhanced to provide support 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 with the Design Advisor at several customer locations that include OLTP and data warehousing applications.

EXP. LEVEL: Beginner,Intermediate



Index tuning

MDC uses

MQT uses

Recommendations for use

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.