How joins run (nested loop, hash join, merge join) and when to partition a table
The three join algorithms and when the database picks each one, hash joins spilling to disk, the LEFT JOIN plus WHERE trap, join decomposition, partitioning vs sharding, MySQL partitioning limits, and the escalation ladder for a table that has grown too big.