wmoore 54341 (7/17/2014)
Does running rebuild/reorganize on an index cause any execution plans that were reliant upon that index to recompile the next time the stored procedure is run?
Rebuild definitely does because it also triggers a statistics update which is one of the things that triggers a recompile. I don't think a reorganize causes a recompile because that does not trigger a statistics update. There's a list of things that can cause a recompile in this BOL article, http://msdn.microsoft.com/en-us/library/ms179294.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question