Categories: Optimizer | Subquery Optimizations

Subquery Works

Contents


For a user-friendly overview, see New Subquery Optimizations in MySQL 6.0 slides from MySQL User Conference 2008.

[edit] Mostly completed work

MySQL 6.0 (6.0.3 in particular) already includes implementations of the following optimizations:


For a short description of the above optimizations, see 6.0 Subquery Optimization Cheatsheet.

The code is in alpha stage (there are known bugs) and you can already try out these optimizations in MySQL 6.0.3 and up.

Preliminary results of survey of the impact on performance are at 6.0_Subquery_Optimization_Benchmarks.

[edit] Work in progress

This is what we're already doing or will definitely be doing in a short-term future:

[edit] Future work

Tasks that we intend to do but don't have any commitments yet


.

Retrieved from "http://forge.mysql.com/wiki/Subquery_Works"

This page has been accessed 2,082 times. This page was last modified 18:57, 20 April 2008.

Find

Browse
MySQLForge
Main Page
Current events
Recent changes
Random page
Help
Edit
Edit this page
Editing help
This page
Discuss this page
Post a comment
Printable version
Context
Page history
What links here
Related changes
My pages
Special pages
New pages
File list
Statistics
Bug reports
More...