What are Included Columns?
- Included column is a ” SQL 2005 ” new feature.
- Creating an index to include non key columns.
- We have a restriction of 900 bytes for index keys and also we can include only 16 columns in a composite index.
- Using included index we can create non clustered indexes that cover more columns in a query.