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
FORALLfunction and bulk bind collections optimize the bulk operations
- Optimized conditional statements: Conditional statements can be optimized by logically ...