2. A method for executing a query, comprising the computer-implemented steps of: executing a query optimizer using a base set of computer processor and memory resources of a computer system to automatically generate a first query access plan for executing said query, wherein each of at least some query access plans generated by said query optimizer is optimized be to 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; subsequently determining that an augmented set of computer processor and memory resources is available to execute said query, said augmented set including said base set of computer processor and memory resources and at least some additional computer resources not included in said base set, said additional computer resources being fee-based computer resources including at least one of processor resources and memory resources, wherein determining that an augmented set of computer processor and memory resources is available is based on a cost of said additional computer resources; responsive to said step of subsequently determining that an augmented set of computer processor and memory resources is available to execute said query, executing said query optimizer using said base set of computer processor and memory resources to automatically generate a second query access plan for executing said query, said second query access plan being different from said first query access plan, wherein said second query access plan is optimized to be executed using said augmented set of computer processor and memory resources subsequent to being generated by said query optimizer; comparing at least one execution parameter of said first query access plan with a corresponding at least one execution parameter of said second query access plan; if said at least one execution parameter of said second query access plan is significantly better than said at least one execution parameter of said first query access plan to justify the cost of said additional computer resources, then dynamically allocating said additional computer resources for executing said query, and executing said query according to said second query access plan using said augmented set of computer processor and memory resources; and if said at least one execution parameter of said second query access plan is not significantly better than said at least one execution parameter of said first query access plan, then executing said query according to said first query access plan using said base set of computer processor and memory resources.
2. A method for executing a query, comprising the computer-implemented steps of: executing a query optimizer using a base set of computer processor and memory resources of a computer system to automatically generate a first query access plan for executing said query, wherein each of at least some query access plans generated by said query optimizer is optimized be to 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; subsequently determining that an augmented set of computer processor and memory resources is available to execute said query, said augmented set including said base set of computer processor and memory resources and at least some additional computer resources not included in said base set, said additional computer resources being fee-based computer resources including at least one of processor resources and memory resources, wherein determining that an augmented set of computer processor and memory resources is available is based on a cost of said additional computer resources; responsive to said step of subsequently determining that an augmented set of computer processor and memory resources is available to execute said query, executing said query optimizer using said base set of computer processor and memory resources to automatically generate a second query access plan for executing said query, said second query access plan being different from said first query access plan, wherein said second query access plan is optimized to be executed using said augmented set of computer processor and memory resources subsequent to being generated by said query optimizer; comparing at least one execution parameter of said first query access plan with a corresponding at least one execution parameter of said second query access plan; if said at least one execution parameter of said second query access plan is significantly better than said at least one execution parameter of said first query access plan to justify the cost of said additional computer resources, then dynamically allocating said additional computer resources for executing said query, and executing said query according to said second query access plan using said augmented set of computer processor and memory resources; and if said at least one execution parameter of said second query access plan is not significantly better than said at least one execution parameter of said first query access plan, then executing said query according to said first query access plan using said base set of computer processor and memory resources. 6. The method of claim 2 , further comprising gathering statistics of computing resources including additional computer resources if available for determining the second query access plan.