Thursday, April 7, 2011

.NET and SQL Server Interview Question - What are difference between Cluster index and Non-Cluster index?


Answer:

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.



Regards,
Please click here to see more .NET and SQL Server interview questions

No comments: