Table Scan or Clustered Index scan

Question

Table Scan or Clustered Index scan

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

A clustered index scan is a table scan. If you put a clustered index on a table you will never actually see a table scan.

All that happens is that it goes straight to the leaf level of the indexe and scans it and since the leaf level of a clustered index contains the actual data for the table its just the same.

But to make any use of an index you need to include a where clause that would elimate some of the rows and for which a suitable index existed.

hth

David