On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni <claudio.na...@gmail.com> wrote: > An explain of the two statements yields the same plan, > anybody knows if they are actually translated in the same plan?
There is a difference. The IN list is sorted so lookups can be done as a binary search. A bunch of OR's just evaluates each condition one at a time until one matches. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org