Index
noun
say it: “IN-deks” /ˈɪndɛks/
A database structure, usually a B-tree, that finds rows by a column's value without reading every row.
What is Index in a relational database?
Index — An auxiliary data structure that helps an RDBMS locate rows without scanning every row.
In a sentence
- “Searching customers by email was slow until we added an index on the email column.”
Level: Journeyman · More Database terms at this level
Updated