patricklambin (12/17/2014)
I think it would be useful to tell us for which version of SQL Server this question is corresponding. I am not sure that with the new query optimizer ( corresponding to SQL Server 2014 ) the answer is the same one than for SQL Server 2012 ( the differences seem important according a session I listened in Paris SQL Server Days 2 weeks ago ).Have a nice day
The QO in 2014 did not change. It is the Cardinality Estimator that changed. The things that can cause a plan to be removed from cache in 2014 are the same as for 2012 and older.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events