Optimizing Dynamic Queries

Wednesday, 14 lipanj, 2006 - 09:00 - 09:45
Namik Hrle

The number of applications using dynamic SQL is increasing. The large enterprise systems such as SAP are based on this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning. Caching of the dynamic SQL statements, impact on virtual storage, reoptimization and EXPLAIN considerations need to be understood in order to take advantage of the feature and ensure optimal execution for the applications that use dynamic SQL.
This presentation will help you gain that understanding.



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 2022

VODICE -  13th - 16th June 2022