Clustered Index Seek is good or not? what is the difference between Clustered Index Seek and Clustered Index Scan?

Post

View All

Ankur Mistry

Clustered Index Seek is good or not? what is the difference between Clustered Index Seek and Clustered Index Scan?

By Ankur Mistry in SQL Server on Apr 22 2016

0
1k
1

Post Your Answer

Jun, 2023 30
The Index seek is faster compared to Index scan. Clustered Index Seek is one of the most efficient ways for SQL Server to find single rows or small ranges, provided there is a filter that can be used efficiently.
- 0