The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 29, 2009
Filed:
Apr. 05, 2005
Eric N. Hanson, Bellevue, WA (US);
Cesar A. Galindo-legaria, Redmond, WA (US);
Lubor Kollar, Redmond, WA (US);
Ganapathy Subramaniam Krishnamoorthy, Issaquah, WA (US);
Sameer Arun Verkhedkar, Issaquah, WA (US);
Evgueni Zabokritski, Redmond, WA (US);
Erik Ismert, Shoreline, WA (US);
Eric N. Hanson, Bellevue, WA (US);
Cesar A. Galindo-Legaria, Redmond, WA (US);
Lubor Kollar, Redmond, WA (US);
Ganapathy Subramaniam Krishnamoorthy, Issaquah, WA (US);
Sameer Arun Verkhedkar, Issaquah, WA (US);
Evgueni Zabokritski, Redmond, WA (US);
Erik Ismert, Shoreline, WA (US);
Microsoft Corporation, Redmond, WA (US);
Abstract
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.