Does Updating Statistics Cause a Recompile if No Data Has Changed?
4 Comments
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…
Read More

