0

I have overcome with the term Clustered index scan over index scan. Does it has any difference.

Shahul
  • 99
  • 3
  • 8
  • Possible duplicate of [What do Clustered and Non clustered index actually mean?](https://stackoverflow.com/questions/1251636/what-do-clustered-and-non-clustered-index-actually-mean) – Esteban P. Apr 04 '19 at 10:33

2 Answers2

0

Yes, there is a difference. A clusted index scan is using a clustered index, a plain index scan is using a non-clustered index.

Have a look at the Microsoft documentation about this topic:

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-2017

Also the differences between those two index were already discussed here: What do Clustered and Non clustered index actually mean?

Esteban P.
  • 2,789
  • 2
  • 27
  • 43
0

A table is normally sortet in order of the clustering index. So if you have your clustering index on attribute A, your table is sortet by this Attribute A.

If your table has a high cluster-ratio, the DBMS can pre-load the data it needs, this is called prefetching. Your queries will run faster if this is the case. However, if your clustering-ratio is too low the pre-fetching is not possible and your query will be less performant. So in generall a clustering-index scan should be faster, if your table is clustered.

Bjeran
  • 15
  • 5