April 11, 2012 at 5:59 am
Hi,
I have an execution plan has been cached and reused numerous times -during this time it has been recompiled at the statement level. If I query the cache and return the plan output; which version of the plan do I get? Is it the latest recompilation or the first compilation etc?
Thanks.
April 11, 2012 at 7:06 am
If it has been recompiled, you're getting the new plan. That's what gets stored in cache.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
April 11, 2012 at 7:55 am
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply