Articles & Content

Archives

What's new from the optimizer in DB2 10 for z/OS? (A02)

Topic: 2011 EMEA

Subtopic: DB2 for z/OS



DB2 10 for z/OS is no exception to the goal of delivering incremental query optimization enhancements to the world’s most respected cost based optimizer. And as delivery of DB2 10 draws closer, the plan solidifies, and beta customer and internal measurement feedback is more readily available. This presentation will share the insight uncovered in the early usage, provide the motivation for each enhancement, and highlight that actual enhancements including: • enhanced plan management, • “safe” query optimization, • improvements to complex OR and IN list processing, • RUNSTATS management and performance improvements, • and more!



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.