September 6, 2011 at 1:12 am
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?
September 6, 2011 at 1:41 am
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
June 14, 2012 at 5:11 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy