Chapter 14. Oracle9i Application SQL Tuning
In this chapter, we will discuss how to monitor SQL statements, add indexes, and make the changes necessary to produce top-performing Oracle-based applications. Oracle uses one of two available optimizers to arrive at a plan, the Explain Plan, of how it will retrieve data and what, if any, indexes will be used. Understanding the contents of this explain plan is essential as well as the Oracle startup parameters that help control SQL performance.
This chapter teaches you the following:
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
