Glossary / Data & databases

Database index

A database index is a lookup structure that lets the database jump straight to matching rows instead of scanning the whole table — like a book's index versus reading every page. Indexes turn multi-second queries into millisecond ones, at the cost of some write overhead and storage. Knowing what to index, and what not to, is a craft learned from real query patterns.