Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.