Articles & Content


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

Topic: DB2 for z/OS

Subtopic: 2007

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


Common Challenges

New Challenge #1

New Challenge #2

New Challenge #3

New Challenge #4

Click Here to Download

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