Section Navigation [Toggle] 7.13 Internal Details of MySQL Optimizations7.13.1 Range Optimization 7.13.2 Index Merge Optimization 7.13.3 Engine Condition Pushdown Optimization 7.13.4 Index Condition Pushdown Optimization 7.13.5 IS NULL Optimization 7.13.6 LEFT JOIN and RIGHT JOIN Optimization 7.13.7 Nested-Loop Join Algorithms 7.13.8 Nested Join Optimization 7.13.9 Outer Join Simplification 7