Articles & Content
Topic: DB2 for LUW
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 - 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.