SQL Tuning

Friday, 24 September, 2010 - 12:45 - 13:45
Raymond Bell

The Dynamic Statement Cache in DB2 has the potential to greatly improve performance for dynamic SQL. As with most things, there are tradeoffs and costs to be considered with this DB2 feature. Meanwhile, the implementation of the cache often changes from release to release. This technical session will discuss the Dynamic Statement Cache to help you understand how the cache is implemented, the contents of the cache and how you can mine the statistics stored there, potential benefits and costs of the cache, including potential issues related to use of the Dynamic Statement Cache.

24 September 2010

Change Management - Raymond Bell
SQL Tuning - Raymond Bell
E-Archive - Zdravko Kelšin


SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020