Understanding the mechanics of Good Index Design

Increasingly many DB2 professionals find that index tuning when done properly can dramatically improve performance. During this presentation we look at the effects of an index on performance, the different types of Index Access are explained and most importantly the key ingredients of good index design are discussed in depth.

Why are Indexes important?
Reduce I/O
Reduce Elapsed time
Reduce CPU
Stage 1 and Stage 2 predicates
Different Types of Indexes (including new Index Types in V8)
Clustering
Unique
Non-unique
Partitioning
Catalog Indexes
Sparse Index
Index on Large Objects
DPSI
NPSI
Variable Length Index Keys
Index Access Paths
Index Only
Matching Index
Non Matching Index
List Prefetch
Multiple Index Access
IN list Index Access
Formula for Designing Efficient Indexes
What makes an Index bad?
Things to keep in mind when designing indexes
Formula for designing Efficiency into your indexes
The ‘Grading System’ explained
Keep workloads in mind
How often is that badly performing SQL executed?
Which SQL statements are critical to the business?
Back to the Accounting reports to check performance