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