Articles & Content

Archives

More Ways to Challenge the DB2 z/OS Optimizer (G06)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Terry Purcell (IBM Silicon Valley Lab)

Ever wondered what can the DB2 z/OS optimizer choose a non-optimal access path? The more that you understand the challenges that make query optimization difficult to perfect, the better equipped you will be to manage the performance of your SQL queries. This presentation will cover more than simple correlation and data skew challenges for optimal access path selection.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Common Challenges

New Challenge #1

New Challenge #2

New Challenge #3

New Challenge #4



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.