Question

Differentiate Table Scan From Index Scan?

Answer 1

An index scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. A scan is the opposite of a seek, where a seek uses the index to pinpoint the records that are needed to satisfy the query. ... Here we can see that this query is doing a Clustered Index Scan.

Answer 2

Answer:

A table scan is performed on a table which does not have an Index upon it (a heap) – it looks at the rows in the table and an Index Scan is performed on an indexed table – the index itself.

Explanation:

Hope this will help you.

plz mark me as BRAINLIEST.