On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni <[email protected]> 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/[email protected]
