What is a full table scan?

Question

Accepted Answer

A full table scan means the query planner has no index it can use, so it reads the table from start to finish. This is fine for small tables or when you are fetching a large portion of the rows anyway, but it becomes expensive on large tables with selective WHERE clauses. Adding an index on the filtered column typically eliminates the scan.