Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Plan Cache RE: SQL Plan Cache

  • August 16, 2012 at 2:07 am

    #1526377

    SQLSACT (8/15/2012)

    To make sure I have this right, if a Query is submitted to SQL Server and it's not part of a Stored Procedure, SQL Server has to generate a plan for it everytime?

    Thanks

    No. Ad-hoc SQL statements have their plans cached and reused just like stored procedures Only difference is the matching is on statement text not object id.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass