Articles & Content
Topic: 2010 EMEA
Subtopic: 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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.