Articles & Content

Archives

Do's & don'ts for finding best performance indexes (A05)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-05-24 (08:30 AM - 09:40 AM)
SPEAKERS: Dirk Johann (SOFTWARE ENGINEERING)

This presentation will go through the motivation for optimizing indexes in DB2 and show you the do's & don'ts for finding best performance indexes. What is the best approach and what are the information sources available for finding the best index candidates. It will also explain why catalog statistics are so important for index usage.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Performance Indexes: what they are

Procedures: best approach for finding them

Information Sources: which sources are available

Index Candidates: how to find them

Catalog Statistics: why they are so important for index usage



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.