Posted by anonieko on 07/17/06 07:15

A lot of detailed discussion explains the difference between clustered
and non-clustered indexes. But very few 'clarifies' why the term used
is 'clustered'. Well, once and for all, this is my take.

*** The 'CLUSTERED' adjective refers to the INDEX being clustered (set
adjacent) to the DATA.

This means if you found the index, the data is already there beside it
(you don't have to look anywhere else). From this note, everything
hopefully becomes clearer to you. (You can now read further in the tech
book :-).


So, the next time you are asked to explain what is a clustered (or
non-clustered ) index think of the above.

[Back to original message]