July 16, 2009 at 4:37 pm
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
July 21, 2009 at 7:51 am
I apologize for not responding back. I've been on vacation. There are some great comments so it will take me some time to look through them all.
Viewing 2 posts - 46 through 46 (of 46 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