Articles & Content


Introduction to query optimization, explain and access plans (D15)

Topic: DB2 for LUW

Subtopic: 2011

This presentation will discuss a number of new query optimization features that were added in DB2 9.7. Besides updating the optimizer's cost model, enhancements were made to materialized query table (MQT) matching, statistical views, the explain facility and optimization guidelines. It is now possible to capture explains from the package cache, activity event monitor tables and directly from the system catalogs. Explain will also report the actual number of rows processed by each access plan operator at query run time. Additionally, a new feature called "access plan reuse" was introduced to stabilize access plans for static SQL across binds and rebinds. Attend this presentation to learn how to use these new features to improve and stabilize your query performance.

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.