Articles & Content

Archives

DB2 for z/OS V9 Selected Query Performance Enhancements (C13)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-5-10 (10:40 AM - 11:40 AM)
SPEAKERS: James Guo (IBM Silicon Valley Lab)

Several exciting V9 query optimization and query performance enhancements will be discussed. Learn how the Global Query Optimization technology improve the performance of correlated and non-correlated subqueries significantly.Learn access path and query performance improvement via generalized sparse index. Learn the benefit of histogram statistics and data repeatition statistics which improve access path and query performance significantly. Query parallelism performance enhancements will also be discussed.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Learn how global query optimization technology improve the performance of correlated and non-correlated subqueries significantly. Learn to find out the new acces path via EXPLAIN

Learn query performance improvement via generalized sparse index. Learn what is sparse index and when sparse index will be utilized by DB2 to improve performance

Learn the benefit of histogram statistics which improve access path and query performance. Learn the new RUNSTATS in V9 which collect the new statistics

Learn query parallelism performance enhancements in V9

Learn the benefit of data repeatition statistics which improve access path and query performance. Learn the new RUNSTATS in V9 which collect the new statistics



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.