Articles & Content


Tuning Access Paths: Red Flags to Look for (G08)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (04:20 PM - 05:20 PM)
SPEAKERS: Joseph Burns (Highmark, Inc.)

As DBAs and application developers we have all had to look at an access path at one time or another. Sometimes a performance issue can be easily seen in the access path, but other times it can be a little more difficult to spot. This is especially true when dealing with explain output that generates multiple query blocks. In this session we will look at explain output and highlight key areas that affect the performance of various SQL statements such as joins, sorts and subqueries. The intent is to focus our efforts on the pieces of the access path that have the most impact on the performance of our SQL.

EXP. LEVEL: Intermediate


Gain a general understanding of key plan table columns

Understand the difference between Sequential and List Prefetch

Understand key performance characteristics of Nested loop and Merge Scan joins

Understand key performance characteristics of Correlated and Non-Correlated subqueries

Gain insight into correcting common access path issues

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.