Optimizing Dynamic Queries

Date: 
Wednesday, 14 June, 2006 - 09:00 - 09:45
Speaker: 
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.
 

 

sqladria

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

facebook
linkid
twitter

 

Events in 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018