This chapter provides practical suggestions for improving the performance of individual queries and transactions. Information in this chapter includes tuning information for both DSS and OLTP applications and explains when and how tuning techniques are appropriate for large queries or for real-time transactions.
This chapter discusses the following topics: