Jul 12, 20261 min read
Database Indexing From First Principles
Understanding what actually happens when a database creates and uses an index.
DatabasesSoftware Engineering
An index trades write cost and storage for read speed. It's a separate, ordered structure the query planner can search instead of scanning every row.