Aikesheng Open Source Community
Nov 23, 2021 · Databases
Understanding Driving (Outer) Tables in MySQL Join Algorithms
This article explains the concepts of driving (outer) and inner tables in MySQL join algorithms, covering Nested‑Loop, Block Nested‑Loop, and Hash Join implementations, how the optimizer selects the outer table, and comparisons with other database systems.
Database OptimizationDriving TableHash Join
0 likes · 10 min read