Index Scan

noun

say it: “IN-deks SKAN” /ˈɪndɛks ˈskæn/

Reading the entries of an index to find the records a query wants, instead of reading every record.

What is Index Scan in a relational database?

Index Scan — Reading multiple entries from an index, often across a range or the full index.

In a sentence

  • “explain() showed an index scan (IXSCAN), so the new index was being used.”
  • “An index scan read 12 index entries to return 12 orders.”

Level: Freelancer · More Database terms at this level

Updated