Ensure Quick Response for Transactions

OLTP transactions return only a few table rows and require a quick response. Certain query plans can provide quicker total response, especially for transactions that update, insert, and delete single table rows. Other query plans can produce a quicker initial response so that users waiting for the rows returned by the query begin to see output quickly even though the total time to complete the query might be somewhat longer. You can adjust transactions and queries to accommodate both of these goals.

To improve response time for OLTP transactions, follow these guidelines:

• Evaluate transactions for effective use of optimizer directives or environment options.
• Evaluate columns that might benefit from being indexed, as described in Create Appropriate Indexes for Transactions.
• Consider rewriting SQL code to take advantage of database server capabilities, as described in Appendix C. Application Tuning Examples.
• Execute the SET OPTIMIZATION FIRST_ROWS statement for sessions that run OLTP transactions.