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

  • August 16, 2012 at 2:25 am

    #1526387

    GilaMonster (8/16/2012)

    In that trivial case, if they are submitted in 3 separate batches, there will be one plan (autoparameterised) used 3 times.

    Thanks

    What would cause SQL Server to generate a seperate plan for the 3rd select statement?

    Thanks