Articles & Content

Archives

F18 - Better access plans with advanced statistical view and optimization profiles.

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



DB2 LUW optimizer has many strategies available to help it generate the best plans for your queries. At times there are hidden relationships within the data that ordinary statistics and configuration data cannot represent. Missing this information the optimizer can make poor choices and queries won't perform. Statistical views can be used to provide much of this hidden information to the optimizer to help generate better plans. Optimization profiles provide another avenue to influence the query plans generated and control settings at a much finer granularity. The combination of these two techniques provide powerful tools to achieve the best performance for your queries.



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.