Dynamically selecting alternative query access plans

A method of providing fee-based processing in a processor system, whereby fees are based on additional computer resources being added for enabling provision of alternative query access plans, the processor system including at least one processor;

• a memory coupled to the at least one processor, a query optimizer residing in the memory;
• and, a manager residing in the memory and executable by the at least one processor, said method comprising the steps of:
• executing said query optimizer using a base set of computer processor and memory resources of said processor system to generate a first query access plan for executing a query, wherein each of at least some query access plans generated by said query optimizer is optimized to be executed using a respective set of computer processor and memory resources subsequent to being generated by said query optimizer, and wherein said first query access plan is optimized to be executed using said base set of computer processor and memory resources subsequent to being generated by said query optimizer;
• executing said query manager using said base set of computer processor and memory resources to evaluate said first query access plan by determining whether additional computer resources are available to execute said query, said additional computer resources being fee-based computer resources comprising at least one of processor resources and memory resources in addition to said base set of computer processor and memory resources, wherein determining whether additional computer resources are available is based on a cost of said additional computer resources;
• responsive to determining that said additional computer resources are available to execute said query, executing said query optimizer using said base set of computer processor and memory resources to generate an alternative query access plan for executing said query, wherein said alternative query access plan is optimized to be executed using an alternative set of computer processor and memory resources subsequent to being generated by said query optimizer, said alternative set including said base set of computer processor and memory resources and said additional computer resources;
• executing said query manager using said base set of processor and memory resources to determine whether a parameter value of the alternative query access plan exceeds a corresponding parameter value of the first query access plan to justify the cost of said additional computer resources, whereby the alternative query access plan is improved over the first query access plan;
• and
• responsive to determining that the parameter value of the alternative query access plan exceeds the corresponding parameter value of the first query access plan, dynamically adding the additional computer resources for executing the alternative query access plan and executing the alternative query access plan using said alternative set of computer processor and memory resources, wherein the manager dynamically adds the additional computer resources based on determining the cost for usage for the additional computer resources.