Cached Plans and Performance
After putting up a primer post about statistics last week, my mind has now jumped to another facet of performance: cached plans. Cached plan objects, whether they are for procedures, ad-hoc statements, views, etc., can have both a negative and positive effect on system performance. There are some general guidelines for when you will want…