Patent ID: 8621482
Filing Date: 2013-12-31
Classification: G06F

Abstract:
1. A method comprising: receiving a plurality of instances of a request to a database system, all instances of the request having a same set of variables to use in executing the request, the values of the variables being supplied by data in a data source; generating a specific plan for executing one instance of the request, wherein generating the specific plan comprises taking into account data in the data source; executing the specific plan on the database system; capturing and saving a system run-time metric and a parsing time for executing the specific plan; and deciding to generate and cache a generic plan for executing the plurality of instances of the request to the database system based on a comparison of the system run-time metric and the parsing time for executing the specific plan, wherein the generic plan does not take into account the data in the data source that is taken into account in the specific plan.