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

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

2
Shouts

Shout it

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

posted by

questpond 773 days, 15 hours, 59 minutes ago

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.

category: Data | clicked: 2 | | source: computerauthor.blogspot.com

| show counter code

tags: .Net Interview Questions, SQL Server Interview Questions

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout