Explains

IDUG NA 2013 Brain Dump

Example of Indexing for a Problem Delete

DB2 Table Scans

The basics of Index Design for DB2

Identifying Problem SQL

Fun with IN-lists and GENROW