DB2 9 Schulung: Improve query performance by indexes-design
This conceptual course is designed to teach you how to design the right indexes for improving query performance, both for single table access and for multiple table access. All of the index utilization possibilities are illustrated as well as the desired column sequence of a multiple column index. Pros and cons of DPSI and NPSI indexes are explained together with the lesser known concepts like index lookaside, implicit uniqueness, sparse indexes, and combination of index screening with list prefetch. The course also clarifies the meaning of many DB2 catalog columns pertaining to the indexes and shows how to correctly use the different RUNSTATS options related to indexes.
