MySQL Forums
Forum List  »  Optimizer & Parser

Re: Need help understanding optimizer behavior in 5.6
Posted by: Rick James
Date: June 23, 2015 07:00PM

> where e.uneven_val between 300 and 32000

What fraction of `e` does that represent in your small test? If it is most of the table, then the optimizer may have decided not to bother with INDEX(uneven_val).

You could create a separate database on the production system for running this test in. That _might_ show you that 5.0 did the same thing. (Or it might not.)

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.