Skip to content

series

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.

1 part · 3 min total

SQL Fundamentals

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

  1. Part 1: Composite Indexes: One Ordering, Not ThreeColumn order decides which queries a composite index can serve. The rule follows from the structure, and so do the cases where it does not hold. · 3 min

Start typing to search the archive.