Help Center/ GaussDB/ Best Practices/ Best Practices for Stored Procedures/ Best Practices for Stored Procedures (Distributed Instances)
Updated on 2025-09-04 GMT+08:00

Best Practices for Stored Procedures (Distributed Instances)

In GaussDB, business rules and logics are saved as stored procedures.

A stored procedure is a combination of SQL, PL/SQL, and Java statements. Stored procedures can move the code that executes business rules from applications to databases. Therefore, the code storage can be used by multiple programs at a time.

For the basic usage of stored procedures, refer to the "Stored Procedures" section in Developer Guide.