Articles & Content

Archives

Index Friend or Foe? (D06)

Topic: DB2 for LUW

Subtopic: 2011



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.



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.