sp_create_plan_guide_from_handle and query hints
-
I was playing around with plan guides and am facing a problem.
I'm trying to create a plan guide using sp_create_plan_guide_from_handle and am unable to figure out where to provide my query hint using this.
I'm able to create a plan guide with a hint using sp_create_plan_guide (using the @hints parameter) but I don't find a similar parameter for sp_create_plan_guide_from_handle. I've tried searching for information and haven't found much on how to get this to work.
Any ideas on how to provide a query hint using sp_create_plan_guide_from_handle?
-
After some more re-reading of BOL - it looks like this is mainly used to freeze a plan and not to provide query hints.
From BOL:
You can use this stored procedure to ensure the query optimizer always uses a specific query plan for a specified query
Too bad there isn't a "recall" feature in the forums
-
I had the same confusion, so I'm glad you didn't "recall" the post.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply