By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,969 Members | 1,522 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,969 IT Pros & Developers. It's quick & easy.

What is the difference between Cluster and Non-Cluster Index?

P: 14
What is the difference between Cluster and Non-Cluster Index?
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies


P: 6
Both Clustered Index and Nonclustered Indexes have same physical structure and stored as a B-Tree structure. But Single table have single clustered index but more than non clustered index. When you create primary key it will create clustered index by default but you can override this behaviour and if you create unique key it will create non clustered index.
2 Weeks Ago #2

Rabbit
Expert Mod 10K+
P: 12,348
That's not quite correct.

A clustered index physically changes the order that the rows are stored on the disk. That is, the order of the rows in the clustered index matches the order of the rows stored on the disk.

A non-clustered index will just have pointers to the rows and so the order of the non-clustered index won't match the order of the rows stored on the disk.
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.