Question - What have included columns when we talk about SQL Server indexing?
Answer -
Indexed with included columns were developed in SQL Server 2005 that assists in covering queries. Indexes with Included Columns are non clustered indexes that
have the following benefits:
- Columns defined in the include statement, called non-key columns, are not counted in the
- a number of columns by the Database Engine.
- Columns that previously could not be used in queries, like nvarchar(max), can be included
- as a non-key column.
- A maximum of 1023 additional columns can be used as non-key columns.