- 7.13.1. Range Optimization
- 7.13.2. Index Merge Optimization
- 7.13.3. Engine Condition Pushdown Optimization
- 7.13.4.
IS NULLOptimization - 7.13.5.
LEFT JOINandRIGHT JOINOptimization - 7.13.6. Nested-Loop Join Algorithms
- 7.13.7. Nested Join Optimization
- 7.13.8. Outer Join Simplification
- 7.13.9.
ORDER BYOptimization - 7.13.10.
GROUP BYOptimization - 7.13.11.
DISTINCTOptimization - 7.13.12. Optimizing
IN/=ANYSubqueries
This background information helps you to understand some of the
terms you see in the EXPLAIN plan
output. If you are rewriting queries to make them more efficient,
or writing your own application logic for lookups, joining, or
sorting, use this information to determine which optimizations you
write yourself and which you can rely on MySQL to perform.