Articles & Content

Archives

Tune SQL like an expert in DB2 UDB z/OS V8 (B07)

Topic: DB2 for z/OS

Subtopic: 2005



DATE: 2005-10-25 (09:45 - 10:45)
SPEAKERS: Terry Purcell (IBM Silicon Valley Lab)

Ever wondered why the DB2 optimizer chooses a certain access path? Before DB2 UDB V8, you had to be an optimizer expert to answer that question. This presentation will outline a method to utilize the extensive access path detail available with V8 Visual Explain and compare with the actual reality for a given query. The end result is that you will be able tune SQL like an expert.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Query Breakdown

Visual Explain

Comparing Estimates with Reality

What do I do if the estimate is incorrect?

Automating the process



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.