Post reply

Execution Plan Version.

  • April 11, 2012 at 5:59 am

    #254655

    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

    #1471814

    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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 11, 2012 at 7:55 am

    #1471852

    Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply