Skip to content

Benefits of Database Procedures

Database procedures provide the following benefits:

  • Enhanced performance

  • Reduced amount of communication between an application and the Actian Data Platform. The Actian Data Platform 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.