System News
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account
By Oystein
March 17, 2017,
Volume 229, Issue 3

Oystein blogs, "One of the major challenges of query optimizers is to correctly estimate how many rows qualify from each table of a join. If the estimates are wrong, the optimizer may choose a non-optimal join order.

Before MySQL 5.7, the estimated number of rows from a table only took into account the conditions from the WHERE clause that were used to set up the access method (e.g., the size of an index range scan). This often led to row estimates that were far too high, resulting in very wrong cost estimates for join plans. To improve this issue, MySQL 5.7 introduced a cost model that considered the entire WHERE condition when estimating the number of qualifying rows from each table. This model estimates the filtering effect of the table's conditions..."

Read More ... [ more...]



Other articles in the MySQL section of Volume 229, Issue 3:

See all archived articles in the MySQL section.

Trending in
Vol 234, Issue 2
Trending IT Articles