What Is The Difference Between Table Scan And Index Scan?
What Is The Difference Between Table Scan And Index Scan? 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. Which is better index