Does Updating Statistics Cause a Recompile if No Data Has Changed? - Brent Ozar Unlimited®

Does Updating Statistics Cause a Recompile if No Data Has Changed? tl;dr — Not necessarily. One of our students asked me a great question: if you update statistics on every table in the database, is that effectively the same as dumping the procedure cache on the instance? Will every execution plan have to be recompiled the next time it is run? I thought it was a great question and it spurred an in

[tgk]

update statisticsをしただけではストアドはリコンパイルされない。(多分、前回のコンパイル後に)当該テーブルが更新されたら、初めてリコンパイルされる