Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-7 (11:10 AM - 12:10 PM)
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 has been 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: Intermediate
What the Design Advisor is
Tieing the Design Advisor to index redesign efforts
MDC Structure and applying the Design Advisor to help. V9 changes
Finding the best MQTs using the Design Advisor
Usage considerations and benchmarks showing performance improvements
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.