Post reply

Does the plan get cached when you have WITH RECOMPILE on a proc?

  • March 28, 2012 at 9:52 am

    #253202

    Thanks.

  • March 28, 2012 at 10:10 am

    #1465792

    Taken from BOL:

    "Instructs the SQL Server Database Engine to discard the plan generated for the query after it executes, forcing the query optimizer to recompile a query plan the next time the same query is executed."

    Steve Hall
    Linkedin
    Blog Site

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

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