On Sun, Feb 25, 2001 at 12:37:32AM -0500, Mark Chalkley wrote:
>
> At this point, there's only 1 row in companies, and 8 in contacts.
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
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
