Indexing From First Principles
Three parts on index design driven by structure rather than rules of thumb — column order, what covering an index really costs, and the case where an index is valuable because of what it leaves out.
Each part starts from the physical structure of the index and derives the rule, rather than stating the rule and listing exceptions. The examples name their engine where behavior differs.
In this series
No published parts yet.