Grant Fritchey (7/16/2009)
TheSQLGuru (7/16/2009)
"hints" is a very broad topic. Did the OPTION RECOMPILE get used widely and cause issues, or are you lumping that in with things like FORCE ORDER, INDEX hints, JOIN TYPE hints, etc, which are indeed fraught with risk?
Unfortunately, I've seen all of the above and more. My favorite was the extensive use of FAST 1 because it provided such a "perfect" execution plan...
That is what I figured. IMHO OPTION RECOMPILE isn't in the same ballpark as the others - unless you have an extraordinary amount of executions. YMMV
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service