|
DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
DB2 9 for z/OS: New Tools for Query Optimization
http://www.redbooks.ibm.com/redpieces/abstracts/sg247421.html?Open
The cost-based optimizer of DB2® for z/OS® has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a brand new Visual Explain.
DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert based query and workload analysis, server enhancements and an Index Advisory function.
These functions are delivered with new functions in DB2 9 for z/OS and two
tools: IBM DB2 Optimization Expert for z/OS and IBM Optimization Service Center for DB2 for z/OS.
This paper book helps you understand the installation, customization and usage aspects of the tools. You are guided through scenarios of gradually increasing complexity where the functions of the tools are exploited for query optimization.
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
© Gernot Ruban