MySQL Forums
Forum List  »  Optimizer & Parser

Re: Fails to use range index in outer joined table
Posted by: Øystein Grøvlen
Date: May 27, 2011 06:14AM

The MySQL's range optimizer can not handle ref access, only range access. In your second example, where adid is constant, the entire range is known at optimize time, and the range optimizer will find that the index can be used to cover the entire range. In the original example, where the range will vary for each access of table2, MySQL will not consider this kind of optimization.

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Options: ReplyQuote

Written By
Re: Fails to use range index in outer joined table
May 27, 2011 06:14AM

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.