Advanced query optimization techniques on large queries.
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.