SQL 2005: Using sp_create_plan_guide with a plan
The BOL article: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/4f5182ec-6a9a-46eb-be6c-87c5d77d9f93.htm elaborates on this limitation.
Plan forcing can be used for most types of SELECT queries. These include queries against tables, clustered and nonclustered indexes, indexed views, and partitioned tables and indexes. USE PLAN cannot be specified with INSERT, UPDATE, or DELETE statements.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment