Glossary: SQL Beyond the Basics

Full table scan

Also written: SCAN, scan

Reading every row of a table to answer a query. It is fine for 2,781 orders but slow on millions.