After Indexing is Correct: Hash Join Spills, Splitting Joins Without N+1 & 4 UPSERT Traps
Advanced database query optimization when indexes are already optimal: Hash Join memory spills to disk, the art of application-side joins without N+1, deterministic SELECT-then-write ID ordering, and 4 dangerous traps of ON DUPLICATE KEY UPDATE.