- A new feature in SQL Server 2005
- non key columns included in addition to the index key columns in an index structure.
In SQL Server 2005, a nonclustered index can be extended by including nonkey columns in addition to the index key columns. The nonkey columns are stored at the leaf level of the index b-tree.