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
Updated