Specifying Query Plans with Plan Forcing
SQL Server 2005 introduces the USE PLAN query hint to force the query optimizer to use a specified query plan for a query. The USE PLAN query hint can be used when the plan for the query is suboptimal and you know of a better execution plan for the query.
In This Section
| Topic | Description |
|---|---|
Describes plan forcing, its uses, and its limitations. |
|
Explains how to implement plan forcing for a query using the USE PLAN query hint. |
|
Explains USE PLAN support for queries submitted with cursors and how to force query plans for queries with cursors. |
|
Provides links to examples that use the USE PLAN query hint and creates a plan guide by using USE PLAN. |