Articles & Content

Archives

Improving Access Paths Through Proper Index Design (DB2 for LUW) (D13)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-11-10 (15:45 - 16:45)
SPEAKERS: Martin Hubel (MHC Inc.)

Many applications enter production with sub-optimal indexing strategies. Regardless of the reasons for this, performance can be substantially improved if indexes are designed or redesigned to better match the needs of the application, to reduce search times, and to avoid sorts.

EXP. LEVEL: Beginner

OBJECTIVES:

objectives - uses of indexes - index structure - Definition of cardinality

multi-column or multiple indexes? - Ordering of columns - Unique or duplicates - include columns

Clustering: the most overlooked Concept - Best choices for the Clustering index - MultiDimensional Clustering

index only access - when and when not To use it

the design Advisor - recommendations for RID indexes - MDC indexes and Clustering



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.