Exciting Optimizer and SQL Performance Enhancements in DB2 9 for z/OS and Beyond

This presentation include the overview and updates for some of the exciting Optimizer and query performance enhancements in DB2 9 for z/OS and beyond.
Learn what is pair-wise join/dynamic index ANDing and why pair-wise join improve
data warehouse query performance significantly. 

Learn the impressive query performance improvement using sparse index and in-memory data cache. Learn what is histogram statistics and other new statistics that  improve access path selection and query performance. Query parallelism and Optimizer performance enhancements that reduce the total cost of ownership will be discussed.  High level overview of some of the exciting Optimizer enhancements beyond DB2 9 will be covered.

Tracks: Applications Programming and Database Administration