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:11 am

    #1653653

    GilaMonster (9/26/2013)

    Plans in XML format please. The text format is awfully hard to read and is missing about 99% of the information.

    In test, nothing. It flies.

    In production, I see CXPACKET only, no blocks, just boatloads of parallelism.