Database indexing —
a library's card
catalog analogy.
Why queries are fast
with one, and the
cost of too many.

Explain Database Indexing With a Library Analogy

Why one query takes 4ms and the other takes 4 seconds.

Prompt

Explain database indexing using a library's card catalog as the analogy — why a query is fast with an index and slow without one, and one tradeoff of adding too many indexes.