Articles & Content

Archives

DB2 LUW Index Design, Best Practices, and Case Studies - Updated (D14)

Topic: DB2 for LUW

Subtopic: 2011



This technical session is all about Indexes - good indexes, bad indexes, how to create indexes, when to drop indexes, where to create indexes, index options, benefits, drawbacks, hazards, and how-to’s. With DB2 doing so much “automatic tuning”, physical design remains the most critical way for the DBA to directly and substantially influence performance. Case studies will demonstrate the most important index design techniques.



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.