Optimizing Queries in Deployed Applications by Using Plan Guides
SQL Server 2005 introduces the sp_create_plan_guide system stored procedure for creating plan guides to optimize the performance of queries. This procedure can be used when you cannot or do not want to directly change the text of the query. Plan guides can be useful when a small subset of queries in a database application provided by a third-party vendor are not performing as expected.
In This Section
| Topic | Description |
|---|---|
Describes plan guides, the types of plan guides, and their uses. |
|
Explains what to consider before creating a plan guide, how to create a plan guide, and the limitations of plan guides. |
|
Specifying Query Parameterization Behavior by Using Plan Guides |
Explains how to create a TEMPLATE plan guide to specify whether a class of queries is parameterized when compiled. |
Explains how to create a plan guide on the parameterized form of a query. |
|
Explains the logical architecture of matching queries to plan guides. |
|
Explains how to facilitate query-to-plan guide matching by using SQL Server Profiler to capture the exact query text when you are creating a plan guide. Also explains how to use SQL Server Profiler to verify the match. |