This talk is looking to fill some of the gap between the ability of reading explain output and the ability to optimize really large queries (imagine a 7 table join). I would like to discuss practical techniques through real-world practical examples, displaying common flaws, encountered throughout my work as a consultant. The talk will cover, but will not be limited to:
- How do you start optimizing large queries.
- Early join, when can it help.
- Effect of join order.
- Range join optimization.
- OR consitions in the query.