Articles & Content

Archives

Fundamentals of DB2 Query Optimization (G05)

Topic: DB2 for z/OS

Subtopic: 2007



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

OBJECTIVES:

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



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.