Tuesday, April 19, 2011

What are difference between Cluster index and Non-Cluster index?

Both of these indexes uses "B-tree" structure but in Cluster index the "Leaf Node" actually points the physical data, but in Non-Cluster index it point’s to the "Row ID" and then the "Row ID" points to the "Leaf Node" of Cluster Index.

Below is the diagram of Cluster and Non-Clustered index.



0 comments:

Popular Posts

Recent Posts

Unordered List

Text Widget

Blog Archive