What Is Non-Clustered Index In Sql Server With Example? In a non-clustered index (or b-tree index), the order of the rows is not the same as how the data actually appears.

A non-unique index is when the indexed column or columns have duplicated values. This type is typically used when linking or joining a table to a second table to return multiple results.

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.