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