Optimizing Queries in Deployed Applications by Using Plan Guides

The sp_create_plan_guide and sp_create_plan_guide_from_handle system stored procedures can be used for creating plan guides to optimize the performance of queries. These procedures 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

See Also

Other Resources