Deferred compilation of stored procedures

1. A method comprising:

invoking a stored procedure in a database, the stored procedure comprising one or more uncompiled database query statements marked for deferred compilation until the stored procedure is invoked at run-time, wherein at least one of the uncompiled database query statements includes one or more variables, and wherein statements marked for deferred compilation are selected for marking based on deferred compilation criteria;

substituting, at run-time, run-time values for the one or more variables in the statements; and

creating, at run-time, an access plan for the statements, wherein the access plan accounts for the statements having the substituted run-time values.

2. The method of claim 1 , further comprising:

optimizing the stored procedure.

3. The method of claim 1 , further comprising:

processing the statements.

4. The method of claim 1 , wherein the deferred compilation criteria comprises whether a statement includes a variable or parameter.

5. The method of claim 1 , wherein the deferred compilation criteria comprises whether a statement includes a JOIN operation with a temporary table created in the stored procedure.

6. A system comprising:

a memory configured to store modules comprising:

an invoking module to invoke a stored procedure in a database, the stored procedure comprising one or more uncompiled database query statements marked for deferred compilation until the stored procedure is invoked at run-time, wherein at least one of the uncompiled database query statements includes one or more variables, and wherein statements marked for deferred compilation are selected for marking based on deferred compilation criteria,

a substituting module to substitute, at run-time, run-time values for one or more variables in the statements, and

creating, at run-time, an access plan for the statements, wherein the access plan accounts for the statements having the substituted run-time values; and

one or more processors configured to process the modules.

7. The system of claim 6 , further comprising:

an optimizing module to optimize the stored procedure.

8. The system of claim 6 , further comprising:

a processing module to process the statements.

9. The system of claim 6 , wherein the deferred compilation criteria comprises whether a statement includes a variable or parameter.

10. The system of claim 6 , wherein the deferred compilation criteria comprises whether a statement includes a JOIN operation with a temporary table created in the stored procedure.

11. A computer-usable medium having computer-executable instructions stored thereon for compiling a stored procedure in a database, execution of which, by a computing device, causes the computing device to perform operations comprising:

invoking the stored procedure, the stored procedure comprising one or more uncompiled database query statements marked for deferred compilation until the stored procedure is invoked at run-time, wherein at least one of the uncompiled database query statements includes one or more variables, and wherein statements marked for deferred compilation are selected for marking based on deferred compilation criteria;

substituting, at run-time, run-time values for one or more variables in the statements; and

creating, at run-time, an access plan for the statements, wherein the access plan accounts for the statements having the substituted run-time values.

12. The computer-usable medium of claim 11 , the operations further comprising:

optimizing the stored procedure.

13. The computer-usable medium of claim 11 , the operations further comprising:

processing the statements.

14. The computer-usable medium of claim 11 , wherein the deferred compilation criteria comprises whether a statement includes a variable or parameter.

15. The computer-usable medium of claim 11 , wherein the deferred compilation criteria comprises whether a statement includes a JOIN operation with a temporary table created in the stored procedure.