What Columns Should Be Included In A Non-Clustered Index? Columns that can be included in a non-clustered index are only the columns that are not keys. An index’s key column is used only as a key in ...

Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.