Clustered index versus index seek


what are the main differences between a clustered index and an index seek?

Best Solution

A clustered index physically places the indexes on disk in the sorted order so go through them faster. It is best when used to iterate over the indexes in sorted order since the disk seeks will be continuous.

An index seek in simply a way to look for an index. This might be a b+tree, a hash, whatever method an index could be looked up.

It's possible to have an index seek over a clustered index, they are not mutually exclusive.