Hash join in MySQL 8.0
summary
MySQL 8.0's hash join feature (introduced in 8.0.18) and subsequent performance improvements are examined, with benchmarking results that quantify those gains. The talk identifies which SQL queries benefit from hash joins, explains the conditions required for the optimizer to choose hash join, and outlines system tuning steps to maximize hash join performance.
AI-written summary · about
