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/my***********...ie.nctu.edu.tw