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

In other subjects