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.