Articles & Content

Archives

A Simple Approach to DB2 for LUW Index Redesign (D09)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-10-15 (09:30 - 10:30)
SPEAKERS: Martin Hubel (Martin Hubel Consulting, Inc.)

Many applications enter production with sub-optimal indexing strategies. Regardless of the reasons for this, performance can be substantially improved if indexes are redesigned to better match the needs of the application.This presentation will review index structure, and discuss a number of ways to redesign indexes without affecting application integrity. This presentation applies to all DB2 platforms, and examples will come from the presenterís experience.

EXP. LEVEL: Intermediate

OBJECTIVES:

Objectives & Benefits of Index Tuning

Index structure

The approach to index redesign

Verification and the Design Advisor

More Examples



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.