At this point, there's only 1 row in companies, and 8 in contacts.
table type possible_keys key key_len ref rows Extra
companies system PRIMARY,comp_id 1 Using filesort
contacts ALL cont_comp_id_idx 8
where used
The query that produced the above is:
EXPLAIN select * from contacts, companies where contacts.comp_id=companies.comp_id
order by contacts.short_name;
Mark Chalkley
---------------------------------------------------------------------
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