New Subquery Optimizations in MySQL 6.0

Architecture and Technology
Location: Ballroom E Level: Intermediate

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.

Sergey Petrunia


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.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.