Databases Reference
In-Depth Information
6
Optimizing
PL/SQL Code
In this chapter, we will cover:
F
Using bind variables and parsing
F
Array processing and bulk-collect
F
Passing values with
NOCOPY
(or not)
F
Using short-circuit
IF
statements
F
Avoiding recursion
F
Using native compilation
F
Taking advantage of the function result cache
F
Inlining PL/SQL code
F
Using triggers and virtual columns
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
.