I got to wondering about that after your question about how many rows were there. I
was just playing with a test copy of the db, preparing to set the log options on the
production one, and noticed that. I rummaged around in the .pdf version of the manual
for over an hour before posting the question. Obviously, I missed it. Maybe I
should've gone to bed earlier instead.
It certainly makes sense for MySQL not to use the index in that case, of course.
As for me, it's another situation of: If you're gonna train a dog, it helps to be
smarter than the dog.
Thanks!
Mark Chalkley
*********** REPLY SEPARATOR ***********
On 2/25/2001 at 12:30 AM Jeremy D. Zawodny wrote:
>MySQL won't use an index on tables with so few rows. It is simply
>faster to scan the whole table. As you tables grow, however, MySQL
>will begin to use the indexes.
>
>This is documented in the manual (though maybe not with hard numbers).
>
>Jeremy
---------------------------------------------------------------------
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
