A SYSTEM AND METHOD TO OPTIMIZE QUERIES ON A VIEW

摘要

A system and method to optimize queries on a view are disclosed. The present invention provides data processing system for processing a query, the data processing system comprising: a processor coupled to a memory storing a plurality of instructions for directing the processor to receive a query comprising a part of query on view; check, based on the part of query on view, in system table, wherein the system table comprises a status associated with the view indicating the compilation of the view; and if the part of query on view found in the system table, fetch a shared object file storing at least one compilation function associated with the part of query on view; use the compilation function as a part of a query execution plan; and execute the query execution plan to display the result.