Articles & Content


Fundamentals of DB2 Query Optimization (G05)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (09:20 AM - 10:20 AM)
SPEAKERS: Shuanglin Guo (IBM, Silicon Valley Lab)

This presentation provides an all-around knowledge base of DB2 query optimization with focus on the fundamentals techniques exploited in DB2 today.

EXP. LEVEL: Beginner


Learn the fundamental techiques DB2 Query Optimization uses today

Learn the architecture of DB2 query optimization

Learn what influences query optimizer on access path decision

Get familiar with EXPLAIN and how to communicate performance issue with DB2 support

Learn the new functions in latest release and how to exploit them

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.