gerald_clark wrote: > You may not have enough rows to make it worthwhile to use an index.
That may be true for the example query I posted that uses the Unit Test data, which is not much. A user of phpOpenTracker reports the same EXPLAIN result for the query performed on tabled with 1.000.000+ rows. -- Sebastian Bergmann http://sebastian-bergmann.de/ http://phpOpenTracker.de/ Did I help you? Consider a gift: http://wishlist.sebastian-bergmann.de/ --------------------------------------------------------------------- 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
