Articles & Content

Archives

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

Topic: 2008 EU

Subtopic: DB2 for LUW



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



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.