Home Forums SQL Server 2016 SQL Server 2016 - Administration Included Column Vs Covering Index RE: Included Column Vs Covering Index

  • August 13, 2017 at 5:13 pm

    #1955097

    SQL-DBA-01 - Sunday, August 13, 2017 7:38 AM

     So currently I have two indexes :

    1. One column and other as included
    2. Two columns as covering index. Initially this index had one column, I just added the other column which was included to other index

    .

    A covering index is one that contains all the columns needed for a query (it's covering for that query). The columns can be in the key, or in the include.
    Could you be a little clearer about what indexes you have?

    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