Articles & Content


Extreme Makeover: Optimal Physical Design Rehab (E09)

Topic: 2008 NA

Subtopic: DB2 for LUW

DATE: 2008-05-21 (09:45 AM - 10:45 AM)
SPEAKERS: Scott Hayes (DBI)

Attendees who want to become Performance Heroes in their organizations must attend this session. After a brief overview of some key performance measurements, several case studies of poor performing statements will be explored along with the physical design techniques and solutions that provide optimized results. We’ll explore indexes, composite indexes, clustering indexes, index only access, MDCs, MQTs, generated columns, dropping indexes, and the performance impacts of DB2 9 compression. Emphasis will be on DB2 LUW with applicability to all DB2 platforms. Come and see how various design techniques can be used to turn ugly performance into beautiful performance at peak efficiency. For those participants shedding tears of joy, a box of tissues will be available.

EXP. LEVEL: Beginner,Intermediate


Key Cost measurements that must be used when evaluating physical designs for cost efficiency and performance optimization: Index Read Efficiency (IREF), Logical Read Costs, Statement Aggregated and Relative costs, ratios.

Best practices physical design for Indexes, and important index considerations.

Not all Indexes are beneficial - when and how to safely drop Indexes.

When to consider special design techniques such as generated columns, MDCs, and MQTs, and implementation suggestions.

Understand the Performance Impacts and Benefits of DB2 9 Compression on physical design solutions.

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.