Post reply

Database Design - What are included columns with respect to SQL Server indexing?

  • February 17, 2010 at 5:50 am

    #230061

    Database Design - What are included columns with respect to SQL Server indexing?

  • February 17, 2010 at 6:23 am

    #1120014

    Test question? Interview question?

    Search in Books Online for 'Include columns' you should find several entries.

    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

  • April 16, 2013 at 1:32 am

    #1606717

    What are included columns with respect to SQL Server indexing?

    A new type of index was developed in SQL Server 2005 and beyond that assists in situations where a covering index is needed.

    Indexes with Included Columns are non clustered indexes that have the following benefits:

    1.Columns defined in the include statement, called non-key columns, are not counted in the number of columns by the database engine.

    2.Columns that previously could not be used in queries, like nvarchar(max), can be included as a non-key column.

    3.A maximum of 1023 additional columns can be used as non-key columns.

    Kindest Regards,

    egpotus DBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply