Using query plans for building and performance tuning services
AssigneeBEA Systems, Inc.
InventorNaveen Gupta
Life of this patent
Estimating the term…
Abstract
In accordance with embodiments of the present invention, there are provided mechanisms and methods for using query plans for building and performance tuning services accessed on behalf of a requestor. These mechanisms and methods for using query plans for building and performance tuning services makes it possible to examine the query plan and response times for query execution. The ability to examine the query plans and response times for query execution makes it possible to improve query efficiency and apply caching more effectively.
Claims15
A method for preparing a query plan for tuning a service, comprising:
- receiving a query from a requester;
- determining from at least one of a plurality of possible ways for satisfying the query, a preferred way for satisfying the query;
- and
- providing the preferred way as at least a portion of the query plan.
A method for receiving information from a server, comprising:
- sending a query to the server;
- receiving a result set of one or more services from the server;
- wherein the server has prepared a portion of the result set of the service(s) according to the server's determination of a preferred way for satisfying the query.
An apparatus for preparing a query plan for tuning a service, the apparatus comprising:
- a processor;
- and
- one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
- receiving a query from a requestor;
- determining from at least one of a plurality of possible ways for satisfying the query, a preferred way for satisfying the query;
- and
- providing the preferred way as at least a portion of the query plan.
Dependencies are inferred from the claim text.