In plain words

Database indexes in plain words

An index is a sorted lookup kept next to a table, like the index at the back of a book. Without it, the database reads every row to find the ones you asked for. With it, the database goes almost straight to them.

Last updated November 20, 2026