Oracle PL/SQL e: Advantages of PLSQL-HIGH PERFORMANCE-3

HIGH PERFORMANCE

1) With PL/SQL, an entire block of statements can be sent to the database at one time. This can drastically reduce network traffic between the database and an application.

2) You can use PL/SQL blocks and subprograms (procedures and functions) to group SQL statements before sending them to the database for execution.

3) PL/SQL also has language features to further speed up SQL statements that are issued inside a loop. PL/SQL stored subprograms are compiled once and stored in executable form, so subprogram calls are efficient.

4) Because stored subprograms execute in the database server, a single call over the network can start a large job. This division of work reduces network traffic and improves response times. Stored subprograms are cached and shared among users, which lowers memory requirements and call overhead.