This talk gives an exhaustive coverage of subquery optimizations in MySQL. The introduction part describes subquery optimizations in MySQL 4.1/5.0. The main part covers new subquery optimizations in MySQL 6.0:
The description of each of the optimizations is accompanied by a demonstration of how the optimization speeds up execution of a real-world query and how it is reflected in the EXPLAIN output.
The talk ends with a description of our plans for future subquery optimization work.
Sergey Petrunia is a member of MySQL Query Optimizer team. He has implemented query optimizer features like index_merge access, partition pruning, semi-join subquery optimizations, and numerous smaller improvements.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.
Download the MySQL Sponsor/Exhibitor Prospectus
Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.
For media-related inquiries, contact confpr@oreilly.com.
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.