Monday 23 May 2011 at 10am CDT -
What's new from the optimizer in DB2 10 for z/OS by Terry Purcell
In episode #4 of The DB2Night Show z/OS Edition,
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. With skip-release migration supported, it is expected that many more customers may adopt DB2 10 in the coming year - so understanding the performance enhancements can be critical for those customers. This presentation will share the insight uncovered from beta customer and early adopters, and provide the motivation for each enhancement including:
· “safe” query optimization,
· improvements to complex OR and IN list processing,
· RUNSTATS management and performance improvements,
· and more!