Articles & Content

Archives

Index Friend or Foe? (D08)

Topic: DB2 for LUW

Subtopic: 2011



DATE: 2011-5-4 (02:45 PM - 03:45 PM)
SPEAKERS: Paul Turpin (S1 Corporation )

Indexes are touted as one of the best performance inventions ever. Many times they are your friend, but they can also be your enemy. This presentation looks at how you can check the health of your indexes with reorgchk and catalog queries. For those of you on pre-DB2 9.7 release, we will look at how to use db2pd tcbstats plus catalog queries to collect index usage into a DB2 table. We will also look at how this information can be connected to explain information. For those of you on DB2 9.7, we will look at some new index information in the catalog including index usage and index statistics.

EXP. LEVEL: Intermediate

OBJECTIVES:

Why indexes are good / why indexes are bad

How to use reorgchk and catalog queries to examine index health

How to use db2pd to collect index usage information and put it into a DB2 table

Connect index usage information with explain information

DB2 9.7 index catalog information examined



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.