Loading patent…
AssigneeMicrosoft Corporation
InventorsEric Hanson, Cesar Galindo-Legaria, Lubor Kollar, Ganapathy Krishnamoorthy, Sameer Verkhedkar, Evgueni Zabokritski, Erik Ismert
Estimating the term…
A system and method for creation, modification and/or use of plan guide(s) is provided. Plan guide(s) can be employed to optimize the performance of query(ies) when it is not possible and/or desirable to change the text of the query directly. Plan guides can be useful, for example, when a small subset of queries in a database application deployed from a third-party vendor is not performing as expected. Plan guides influence optimization of queries by attaching query hints to them. In accordance with an aspect of the subject invention, a query plan execution system is provided. The system includes an execution component, a query optimizer, and, a plan cache. Plan guides and other associated metadata are stored in a plan guide metadata store.
A query plan execution system comprising:
A method of executing a query within an entity comprising:
A data packet transmitted between two or more computer components that facilitates query optimization, the data packet comprising:
Dependencies are inferred from the claim text.