Originally published in 2009, I updated this in 2019 with an example showing an effect on the plan cache.