RDB Design Series Part 6: Index Design and JOIN Strategy — All the Way to the Optimizer
Go beyond index basics into design-level thinking. Covering indexes, partial indexes, cardinality analysis, JOIN algorithms (Nested Loop, Hash, Merge), reading EXPLAIN ANALYZE, and the N+1 problem. Turn index creation into index design.
