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