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.

clip_image001

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

clip_image002

Then if you examine the cache plan with following query.

clip_image003

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

No comments:

Post a Comment