Are you getting the matching columns you designed for? 2. **ACCESSTYPE** — Is DB2 using your index or scanning? 3. **PREFETCH** — 'S' (sequential) is normal; 'L' (list) suggests poor clustering 4. **COST_CATEGORY** — 'B' means default statistics — run RUNSTATS immediately 5. **CLUSTERRATIO** — Below