Home Forums SQL Server 2005 SQL Server 2005 General Discussion Creating indexes with same key column but different include RE: Creating indexes with same key column but different include

  • July 1, 2015 at 8:49 am

    #1809525

    Steve Jones - SSC Editor (7/1/2015)

    AFAIK, the order of columns in the include doesn't matter.

    Correct.

    Order of columns matters in the key, not in the include

    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