SQL performance Execution time can be drastically improved, when using SQL instructions in the right way. Performance with dynamic SQL Comparing static SQL statements and dynamc SQL statements used in a loop. Performance with transactions Commit database changes by blocks of transaction speeds performance with some database servers. Avoiding long transactions Long transactions consume resources and decrease concurrent data access. Declaring prepared statements Optimize prepared cursor statements by using the FROM clause of DECLARE CURSOR. Saving SQL resources SQL cursors and prepared statement consume resources that should be freed when useless. Optimizing scrollable cursors A programming pattern to get fresh data from scrollable cursors.