Hi, we have an adhoc select query being generated by EF and uses literal strings in the where clause.The query is running very slow and I am wondering if forced param. can be of any use in this case.
Has anyone used this for such purposes, what are the pros and cons of forced param. I am aware of one that it flushes everything from the plan cache except of current running queries.
Also, I was thinking if at all this needs to be enabled then would a plan guide be a good option to do this instead if enabling it for the whole DB.