Nonclustered Indexes

Nonclustered indexes have the same B-tree structure as clustered indexes, with two significant differences: –The data rows are not sorted and stored in order based on their nonclustered keys. –The leaf layer of a nonclustered index does not consist of the data pages.

Read More - Register for Free Membership