Michael Braun wrote: > > I'm using mysql 3.23.41 on MacOSX... > The problem is, that MySQL isn't able to use indexes for OR in the WHERE > clause yet and therefore the additional OR prevents optimal use of > indexes. MySQL uses only one index for a select, so it can't use an index > when there is an OR in the where clause.
Wow, that's fairly unpleasant... Can I shout "ME TOO!" please... cheers, Chris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php