Articles & Content

Archives

The Effect of Distribution and Correlation Statistics on the DB2 Optimizer (A03)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-7 (01:40 PM - 02:40 PM)
SPEAKERS: Tom Moulder (TREX Associates, Inc.)

Ever wondered about DB2 performance? Why some statements work well and not others? This presentation will explain the difference between DB2 without help and DB2 with help. The particular help that will be discussed is the ability of DB2 to collect statistics concerning data content that can be used to improve performance. Don't let the title scare you. At no time during the presentation will I ever use anything more that addition, subtraction, multiplication and division. The longest calculation is of four values. Simple Math can be used to unlock the secrets of DB2.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

The attendee will learn how the various inputs to the Optimizer determine the selected access path

The attendee will learn what distribution statistics are and how they influence access path selection in the DB2 Optimizer

The attendee will learn what coorelation statistics are and how they influence access path selection in the DB2 Optimizer

The attendee will learn of changes in the DB2 Optimizer in Version 8 and how these changes can be exploited to improve performance during Version migration

The attendee will learn how to capture distribution and coorelation statistics and update the catalog so that the DB2 Optimizer can use these values to improve access paths



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.