sp_create_plan_guide_from_handle and query hints

• winash

  SSChampion

  Points: 11446

  More actions

  September 6, 2011 at 1:12 am

  #244266

  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?

• winash

  SSChampion

  Points: 11446

  More actions

  September 6, 2011 at 1:41 am

  #1377204

  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 🙂

• AlBran LVP

  SSC Eights!

  Points: 857

  More actions

  June 14, 2012 at 5:11 pm

  #1501320

  I had the same confusion, so I'm glad you didn't "recall" the post. 🙂