Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan RE: Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

  • September 26, 2013 at 10:21 am

    #1653658

    You're really not making this easy...

    For anyone else who wants to have a look, plans are attached, edited to so that they're valid XML (had hidden illegal characters in them) and converted. Though I just noticed one of them is an estimated plan, so missing all the run-time information

    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