Does a RECONFIGURE statement flush the Plan Cache?

A few weeks ago I got quite an interesting question from a weblog reader: does a RECONFIGURE statement flush the Plan Cache? Normally my answer to this question is a simple Yes, but as we have sometimes found out together the real answer is an “it depends”. Let’s have a look at it, and why …

Does a RECONFIGURE statement flush the Plan Cache? + read more