New Subquery Optimizations in MySQL 6.0
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:
- Table pullout
- Duplicate elimination
- FirstMatch
- InsideOut scan
- Materialization
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.
People planning to attend this session also want to see:
Sergey Petrunia
MySQL
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.
O'Reilly Home | Privacy Policy | Contact Us | Sitemap | webmaster@oreilly.com
Event Software Powered by Expectnation
© 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938
Diamond Sponsors
Platinum Sponsors
Gold Sponsors
Premier Media Partner
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.
Download the MySQL Sponsor/Exhibitor Prospectus
Media Partner Opportunities
Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.
Press and Media
For media-related inquiries, contact confpr@oreilly.com.
MySQL Conference Newsletter
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
Contact Us
View a complete list of MySQL contacts.