Articles & Content
Topic: DB2 for z/OS
DATE: 2006-10-5 (09:00 - 10:00)
SPEAKERS: Terry Purcell (IBM Silicon Valley Lab)
Ever wondered why the DB2 optimizer chooses a certain access path? The wrong index, poor table join sequence? Before DB2 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.
EXP. LEVEL: Beginner,Intermediate,Advanced
Comparing estimates with reality
What to 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.