← recall

table scan term

reading every row of a table

Sometimes the right plan (small table, most rows match). Often a bug for large tables — usually means missing index, bad statistics, or function preventing index use.

aliases: seq scan, sequential scan, full table scan

topics: databases, performance

references:

• Use the Index, Luke!