# Table Scan

*noun*

say it: **“TAY-bul SKAN”** **/ˈteɪbəl ˈskæn/**

Reading every row of a table to find the ones a query wants, because no index can jump straight to them.

## What is **Table Scan** in a relational database?

**Table Scan** — Reading a table broadly rather than locating rows through a selective index path.

## In a sentence

- “The email lookup was a **table scan** until the index was added.”
- “On ten rows a **table scan** is instant; on ten million it isn't.”

Level: Freelancer · [More Database terms at this level](https://www.ask-codey.com/glossary?category=database&level=4)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/table-scan
