What is the difference between a clustered and non-clustered index in MS-SQL?

Hi:

I know I've seen multiple posts of the answer to this question, but what is the answer in straightforward, easy to understand terms.

What is the difference between a clustered and non-clustered index in MS-SQL?

Thanks,
JohnB
LVL 1
jxbmaSoftware ConsultantAsked:
Who is Participating?
 
Habib PourfardSoftware DeveloperCommented:
Clustered index: The rows are stored physically on the disk in the same order as the index in database. therefore you can have only one clustered index for a table.
Reading is faster while writing to a table with a clustered index can be slower.

Non clustered index: Only has pointers to the physical rows, so they aren't physically sorted on the disk. you can have many non-clustered indexes on a table; each new index will increase the time it takes to write new records
0
 
sachitjainCommented:
A clustered index is something that physically determines the organization of records in any table. Example: a language dictionary where physical organization of all words is based on alphabets in those words starting left to right. That's why husband stands behind foolishness and wife appears before wisdom in the dictionary. :)

On the other hand non clustered index is a separate structure that helps you traverse through records in the table like an index of a book that may tell you that chapter number 7 of that book starts at page 86 and ends at page 104.

That is the reason why we could have only one clustered but multiple non clustered indexes within a table.

Following is one link that might help you more
http://www.itbully.com/articles/sql-indexing-and-performance-part-2-clustered-and-non-clustered
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.