Indexes that actually get used
Composite column order, covering indexes, and the six query shapes that make the planner ignore the index you just added.
Intermediate9 min
#databases
#performance
B-tree internals, composite index column order, covering indexes, and the cost of every write.
3 articles
Composite column order, covering indexes, and the six query shapes that make the planner ignore the index you just added.
A free, database-agnostic book on SQL indexing — the clearest explanation anywhere of why composite column order decides everything.