Was this helpful?
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.
Last modified date: 10/30/2024