GSE UK Conference 2009

z/OOM into the 6th Decade with

Session CD: How will this index reduce I/O?.

Session Speaker: Terry Purcell (IBM)

Session Chairman: Phil Grainger (Indep)

When: Wednesday 4th November @ 15:30

Where: Hungaroring

Presentation_Button.gif - 7602 Bytes

Abstract:

There are numerous myths about when indexes are beneficial for performance, and how the columns should be ordered. This presentation will demonstrate how clustering and indexing complement each other reduce data I/O, when index-only access can be beneficial, and index design to encourage table join sequence and method.

Terry Purcell is Chief Architect, DB2 for z/OS Optimizer Development at the IBM Silicon Valley Lab


thinblue.gif - 1017 Bytes

Close window Close this Window

thinblue.gif - 1017 Bytes

Last Update: Monday, 02 November 2009 @ 22:53

(c) Copyright 2009 GSE UK Region