Home Forums SQL Server 2012 SQL 2012 - General Performance with Referencing or not referencing, index or with index? RE: Performance with Referencing or not referencing, index or with index?

  • November 27, 2015 at 1:40 am

    #1842582

    No, I said if there is no existing index on the Detail table on MasterID, create one on (MasterID, ID). If there is an existing one on MasterID, add the ID column to it.

    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