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