Stored Procedures
Some database systems allow for the creation and storage of Stored Procedures.
Stored Procedures is a collection of procedural SQL statements. This is defined on the server and accepts a list of parameters which are used within the statements. A result is returned.
These are much faster due to the fact they are pre-compiled.