Viewing 2 posts - 1 through 2 (of 2 total)
Looks like updating statistics alone does not cause a recompile, at least in SQL Server 2014:
http://www.brentozar.com/archive/2015/01/updating-statistics-cause-recompile-no-data-changed/
If data hasn't changed, then no recompile.
January 2, 2015 at 4:32 pm
#1767505
Yet another way to cheat... and learn some new languages in the process 😀
SELECT *
FROM sys.messages
WHERE message_id = 2714
December 30, 2014 at 5:13 pm
#1767113