SQL Reference Guide > SQL Reference Guide > Understanding Database Procedures, Sessions, and Events > How Database Procedures Are Created, Invoked, and Executed > Benefits of Database Procedures
Was this helpful?
Benefits of Database Procedures
Database procedures provide the following benefits:
• Enhanced performance
• Reduced amount of communication between an application and the DBMS Server. The DBMS Server retains the query execution plan for a database procedure, reducing execution time.
• Control over access to data. The DBA can use the GRANT statement to enable a user to execute a procedure even if the user does not have permission to directly access the tables referenced in the procedure.
• Reusability and reduced coding time. The same procedure can be used in many applications.
• The ability to enforce integrity constraints (when used in conjunction with rules).
Last modified date: 08/29/2024