On Thursday, 21. February 2002 12:46, Natalino Picone wrote: > Hi, > I found that mysql doesn't used indexes if there is a <> in the where > statement... > for example > mysql> explain select * from testtable where id <> 5;
It would only make sense to use an index, when you want to select the id field (SELECT id from testtable where id <> 5). Otherwise a table scan would be faster. Regards George --------------------------------------------------------------------- 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