The ESR rule: how compound indexes really get used
Equality, Sort, Range — the three letters that decide whether your compound index is a thoroughbred or a paperweight. We dissect the planner's prefix-matching logic on a 40M doc collection.
Equality, Sort, Range — the three letters that decide whether your compound index is a thoroughbred or a paperweight. We dissect the planner's prefix-matching logic on a 40M doc collection.
totalKeysExamined, totalDocsExamined, nReturned — the three numbers I look at first, and what their ratios tell me before I read a single index.
How to fake LIKE '%foo%' on Mongo with trigrams, a pre-computed token array, and a clever multikey index. ~12ms p99 on 8M documents.