2009 EU

Access Path Stability for Dynamic Queries (F04) 

Oct 06, 2009 03:00 PM

DATE: 2009-10-6 (08:30 - 09:30)
SPEAKERS: Thomas Baumann (Swiss Mobiliar)

To rebind or not after a new DB2 release, a maintenance upgrade, or after running RUNSTATS has been a crucial question for a long time. After the implementation of optimizer hints, the REOPT bind option, and access plan management, things became easier for static SQL queries. But for dynamic queries, it is still at the customer's responsibility to ensure access path stability. This presentation shows methods for your dynamic workload to avoid access path regression and to correct unexplainable access paths, such that you don't dread your next RUNSTATS run, application or DB2 release, or your next maintenance upgrade.

EXP. LEVEL: Beginner,Intermediate,Advanced


Reasons of access path instability

Access path fallback for static queries

Limiting exposure to instability for dynamic queries

Access path corrections for dynamic queries

Query performance management as a continuous process

pdf file
EU09F04.pdf   248 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.