MySQL Forge

Resources for the MySQL Community

Category: Optimizer

New Optimizer features in 6.0

This page will contain a list of new 6.0 optimizer features

[edit] Flagship optimizer features

• WL#2475 Multi Read Range for MyISAM/InnoDB
• Index Condition Pushdown

• WL#2980: Subquery optimization: Semijoin
  • WL#3740: Subquery optimization: Semijoin: Pull-out of inner tables
  • WL#3741: Subquery optimization: Semijoin: Duplicate elimination strategy
  • WL#3750: Subquery optimization: Semijoin: First-match strategy
  • WL#3751: Subquery optimization: Semijoin: Inside-out strategy
• WL#1110: Subquery optimization: Materialization

(for more information about subquery optimizations see Subquery_Works)

• TODO add more

[edit] Minor improvements

• The code that removes equalities that are guaranteed to be true by use of ref access now works better

  it removes equalities in a broader set of cases.

• TODO add more