First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Continued from the previous page:
Use procedures, functions and packages to maximize cursor re-use. These stored database programs support parameter passing; thus, each caller can use the SQL within the stored procedure with different values. For example, in a common production system where more than one user is using a GUI to access the database, the very first to use the screen will cause the code to be optimized and stored in the shared pool. Further users will re-use the optimized versions of the statements, saving on the re-parsing overhead.
Refer to SkillBuilders’ SQL Tuning for Developers and DBAs course for more information on this subject.