The explain plan isn't anything I wouldn't ordinarily expect - a full table scan:
+-------+------+---------------+------+---------+------+---------+-----------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+------+---------------+------+---------+------+---------+-----------------+ | tbe1 | ALL | NULL | NULL | NULL | NULL | 8190652 | Using temporary | +-------+------+---------------+------+---------+------+---------+-----------------+ --- Justin Spies <[EMAIL PROTECTED]> wrote: > Henry, > The information you've posted is a good start, can you post the results of > an EXPLAIN command? That would go a long way towards finding a solution. __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
