5 ms·
MySQL only supported “nested loop” joins in 5.5 and below. Hash and merge joins were introduced in 5.6. Depending on when you originally did the query, maybe y
by adrianmsmith 8y ago
MySQL only supported “nested loop” joins in 5.5 and below. Hash and merge joins were introduced in 5.6.
Depending on when you originally did the query, maybe you were using 5.5 or below, which would explain why you now can’t reprodce it?
- dekhn 8y agoIt's very possible. I was running the query ~14 years ago and it wouldn't surprise me if any number of improved condition pushdown mechanisms were implemented.