[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> on Thursday, October 07, 2004 12:30 PM said:
> You set up your situation very well but for one small item. Please > allow me to kindly introduce you to the EXPLAIN command.... > > http://dev.mysql.com/doc/mysql/en/EXPLAIN.html hey! that looks like it might come in useful. :) i didn't know about this. > Post the results from using that on your query and we will be good to > go :-) here you are: +-------+--------+---------------+------+---------+------+------+------- --------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+--------+---------------+------+---------+------+------+------- --------------+ | pmed | system | NULL | NULL | NULL | NULL | 0 | const row not found | | p | ALL | NULL | NULL | NULL | NULL | 733 | where used | | pc | ALL | NULL | NULL | NULL | NULL | 753 | where used | | pmas | ALL | NULL | NULL | NULL | NULL | 1410 | | +-------+--------+---------------+------+---------+------+------+------- --------------+ 4 rows in set (0.00 sec) thanks, chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
