Oracle7 Server Tuning
CHAPTER 7. Tuning SQL Statements
Tuning your SQL statements is an important part of getting the best possible performance from Oracle. You should tune your SQL statements before your database administrator tunes Oracle itself:
- Even if you are not familiar with the internal workings of Oracle, you can significantly improve performance by tuning your application based on your knowledge of how Oracle executes SQL statements.
- If your SQL statements are not tuned well, they may not run well, even if Oracle is tuned well.
This chapter tells you
This chapter assumes that you are familiar with the concept of an execution plan and how the Oracle optimizer generates one. For this information, see Chapter 5, "The Optimizer".