Patent ID: 7912835
Filing Date: 2011-03-22
Classification: G06F

Abstract:
1. A computer-implemented method of performing a query, comprising: compiling a query statement, by using a processor, to generate an execution plan with context information, wherein the execution plan with the context information will be retrieved during execution of the query statement, wherein during compilation of the query statement the context information is gathered and stored as an opcode, and the context information identifies a bind value for a bind variable of the query statement, wherein the bind variable is a placeholder in a query statement that must be replaced with a value before execution of the query statement; executing the query statement, wherein the act of executing the query statement comprises retrieving the execution plan with the context information and performing operations of the opcode associated with the context information such that the context information, gathered and stored as the opcode during the compilation of the query statement, is not gathered during the execution of the query statement; and storing the bind value in a volatile or non-volatile computer-usable medium or displaying the bind value on a display device.