Stable queries

Presentation will cover how plan stability for static and dynamic SQL can help protect you from access path regressions. For static SQL that means taking advantage of the plan management feature – with the various options available, that apply to both REBIND and to BIND. Stability for Dynamic SQL is evolving more rapidly, with new changes coming in DB2 12 that provide stability of performance for longer than the life of an SQL in the dynamic statement cache.

Aby pobrać prezentację należy się zalogować.