Newsletter
Every Database Index Is a Bet on Your Read/Write Ratio
An index is a redundant, sorted copy of a subset of your data, maintained by the database on every write. When you CREATE INDEX ON orders(customer_id), the database builds a B-tree over that column. Every insert into orders now writes twice: once to the table, once to the