Java High-Performance Architecture

Jul 26, 2015 · Databases

Understanding MySQL’s Nested Loop Join: How It Works and Why Indexes Matter

MySQL uses only the Nested Loop Join algorithm, iterating each row of the left table and comparing it with every row of the right table, and when multiple tables are involved the intermediate results are repeatedly joined, making proper indexing crucial for performance.