Post reply

Is there a way to force recompilation of already running query based on plan handle

  • January 28, 2013 at 9:51 pm

    #269607

    Hi,

    Is there any way to force the recompilation of an already running query based on plan handle?

    Thanks.

  • January 29, 2013 at 3:56 am

    #1581987

    Not for a query that is running, no. You can use the plan handle to recompile a query in cache, but if it's actively running, it will have to complete. Any other calls against the same plan in cache will get a new plan, but that existing execution will have to complete.

    "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

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

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