What to Do When the MySQL Optimizer Overestimates the Condition Filtering Effect

(Øystein Grøvlen) In my previous blog post, I showed an example of how the MySQL Optimizer found a better join order by taking into account the filtering effects of conditions. I also explained that for non-indexed columns the filtering estimate is just a guess, and that there is a risk for non-opti

Read More - Register for Free Membership