Could anyone tell me the difference between the following two explains? It seems the first takes longer to execute.
This first query is like so... select m.*, mi.age from members m, members_addtl_info mi where m.nick like '%anynickname%' AND m.nick = mi.nick order by nick desc, account_login_last desc limit 0, 21 +-------+--------+---------------+---------+---------+---------+--------+--- ------------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+--------+---------------+---------+---------+---------+--------+--- ------------------------------+ | mi | ALL | PRIMARY | NULL | NULL | NULL | 740053 | Using temporary; Using filesort | | m | eq_ref | PRIMARY | PRIMARY | 15 | mi.nick | 1 | where used | +-------+--------+---------------+---------+---------+---------+--------+--- ------------------------------+ 2nd query seems alot fasteer..... select m.* from members m where m.nick like '%bigsh523%' order by nick desc, account_login_last desc limit 0, 21 +-------+------+---------------+------+---------+------+--------+----------- -----------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+------+---------------+------+---------+------+--------+----------- -----------------+ | m | ALL | NULL | NULL | NULL | NULL | 736939 | where used; Using filesort | +-------+------+---------------+------+---------+------+--------+----------- -----------------+ Any ideas why? What is the difference between Using Temporary and where used? Thanks! TOM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
