Cari Blog Ini

28 Juni 2012

Types of B-tree Indexes

There are two types of B-tree indexes:
1. Clustered indexes
A clustered index stores the actual rows of data in its leaf nodes.

2. Nonclustered indexes.
A nonclustered index is an auxiliary structure that points to data in a table.


 

Source:
Microsoft SQL Server 2000 Administrator's Companion eBook