Query processor could not produce a query plan because of the hints defined in this query.

Answers

• Options

  David_D Posts: 26 Bronze 2

  February 24, 2021 5:36PM

  Hello @MGibson,
  
  Thanks for reaching out!
  
  I have not personally encountered this issue but it does seem related to SSMS (which you may be able to raise a bug with Microsoft). Another user that had the same error along with the forceseek query hint:
  https://dba.stackexchange.com/questions/222640/query-processor-could-not-produce-a-query-plan-because-of-the-hints-defined-in-t
  

  In my case I got the same error with my query where somebody used with forceseek hint.
  Finally I figured out that table was a HEAP and the creation of a Clustered Index solved the problem.

  
  I hope this helps you out.
  
  Kind regards,
  David

  0 · Share on Twitter