O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tuning PL/SQL code

Once the DBA configures the database for optimal performance, the code development plays an essential role in PL/SQL performance. Now, we will discuss certain areas of improvements. These improvements can be made during the development stage so as to avoid the nightmares later.

The tunable areas identified and covered in this section are as follows:

  • Avoiding implicit typecasting: Identification of appropriate data type
  • Modularizing the programs: Modular programming and effective code sampling shares the work load
  • Usage of bulk bind collections and the FORALL function : Usage of the FORALL function and bulk bind collections optimize the bulk operations
  • Optimized conditional statements: Conditional statements can be optimized by logically ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required