Method and system for efficient processing of polymorphic table functions
AssigneeOracle International Corporation
InventorsAtif Chaudhry, Lei Sheng, Shashaanka Agrawal
Life of this patent
Estimating the term…
Abstract
Described is an approach for performing an efficient processing of table functions/polymorphic table functions. The approach does not create additional cursors for processing a table or polymorphic table function invoked within a SQL statement. Instead, the approach handles the SQL statement that invokes the table/polymorphic table function as a single cursor.
Claims46
A computer implemented method for performing processing of a table function, comprising:
- receiving a structured query language (SQL) statement comprising a table function (TF);
- identifying a definition of the TF;
- identifying one or more predicates in the SQL statement;
- and
- optimizing processing of the TF by applying the one or more predicates to an input source for the TF.
A system for performing processing of a table function, comprising:
- a processor;
- a memory for holding programmable code;
- and
- wherein the programmable code includes instructions for receiving a structured query language (SQL) statement comprising a table function (TF), identifying a definition of the TF, identifying one or more predicates in the SQL statement, and optimizing processing of the TF by applying the one or more predicates to an input source for the TF.
A computer program product embodied on a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method for performing processing of a table function, comprising:
- receiving a structured query language (SQL) statement comprising a table function (TF);
- identifying a definition of the TF;
- identifying one or more predicates in the SQL statement;
- and
- optimizing processing of the TF by applying the one or more predicates to an input source for the TF.
A computer implemented method for performing processing of a table function, comprising:
- receiving a structured query language (SQL) statement comprising a table function (TF);
- and
- creating one cursor for the SQL statement without creating a specific cursor for the TF.
Dependencies are inferred from the claim text.