Thursday, July 19, 2012

Cache Plans for Estimated Queries

Let me put this in simple. Yes when you click estimated query plan as shown in the below image it will cache the query plan.


Let us verify this.

Let us clear the cache first and write the query first and then if you click the Display Estimated Execution Plan button


Then if you examine the cache plan with following query.


you can see that query is cached. This is fixed in SQL Server 2012.

No comments:

Post a Comment