What is the benefit of clustered index against Non-Clustered ?
A Clustered index is a type of index in which table records are physically reordered to match the index. A Non-Clustered index is a special type of index in which logical order of index does not match physical stored order of the rows on disk
and
Cluster index offers faster data accessing, on the other hand, Non-clustered index is slower.
But why it's faster? Anyway need to
- Search at index tree
- Follow the link to get the data from the disk (unless it's covered, but let's speak generally)
No matter next index data is near on the disk, isn't it?