database index seek vs scan | What is Index Scan ,Index Seek and Table Scan?


What is Index Scan ,Index Seek and Table Scan?

An index scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. index seek happens when data is searched among the index.Please watch …