A curated list of engineering series, deep dives, and notes related to #Query Tuning.
Master multi-column composite indexes in MySQL: leftmost prefix rules, range predicate traps, Index Condition Pushdown (ICP), and covering indexes.