This chapter explains how the PL/SQL compiler optimizes your code and how to write efficient PL/SQL code and improve existing PL/SQL code.

• PL/SQL Optimizer

• Candidates for Tuning

• Minimizing CPU Overhead

• Bulk SQL and Bulk Binding

• Chaining Pipelined Table Functions for Multiple Transformations

• Overview of Polymorphic Table Functions

• Updating Large Tables in Parallel

• Collecting Data About User-Defined Identifiers

• Profiling and Tracing PL/SQL Programs

• Compiling PL/SQL Units for Native Execution