Introduction
In this chapter, we will focus on PL/SQL code, such as stored procedures, functions, and triggers.
The topics explained in this chapter are easier to apply than those in Chapter 4, Optimizing SQL Code because you can make changes to PL/SQL code without having to rebuild the entire application—and they can be just as easily reversed if something doesn't work as expected.
It is relatively easy to obtain great performance improvements by tuning PL/SQL code with very little effort. As always, we have to measure the results before and after our changes, using the process introduced in Chapter 1, Starting with Performance Tuning in the recipe The performance tuning process.
