Articles & Content


Get Up to Speed with MultiDimensional Clustering (D07)

Topic: 2006 NA

Subtopic: DB2 for LUW

DATE: 2006-05-09 (04:00 PM - 05:10 PM)
SPEAKERS: Brad Price (Physicians Mutual Insurance Company)

MultiDimensional Clustering(MDC) has been available since UDB LUW V8 was introduced in 2003. MDC can provide significant performance improvements in many cases. Yet, many organizations have not fully embraced MDC or perhaps have had a negative experience. This presentation will explain the basics of MDC and how it can improve performance. Design guidelines and mistakes to avoid will be discussed.

EXP. LEVEL: Beginner


Traditional clustering explained

How MDC works

Design guidelines

Sizing MDC tables

Recent Improvements to MDC

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!

Download File
Click to Download

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