(root@localhost) [test]> explain select e.id from egyik e,masik m where e.id=m.id and e.duma='aaa'order by m.szam asc; +------+-------------+-------+------+---------------+-------+---------+-----------+------+-----------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+-------+---------+-----------+------+-----------------------------------------------------------+ | 1 | SIMPLE | e | ref | PRIMARY,e_idx | e_idx | 767 | const | 1 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | m | ref | m_idx | m_idx | 4 | test.e.id | 1 | Using index | +------+-------------+-------+------+---------------+-------+---------+-----------+------+-----------------------------------------------------------+ 2 rows in set (0.00 sec)
How can i eliminate the "Using temporary" and "Using filesort" messages?
Thank you,
Lay
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jun 12
Antonio Fernández Pérez Re: Order column in the second table
Jun 12, 2014; 13:36
Antonio Fernández Pérez
Re: Order column in the second table
Jun 12
Lay András Re: Order column in the second table
Jun 12, 2014; 13:42
Lay András
Re: Order column in the second table
Jun 13
yoku ts. Re: Order column in the second table
Jun 13, 2014; 10:59
yoku ts.
Re: Order column in the second table
Jun 13
Lay András Re: Order column in the second table
Jun 13, 2014; 10:29
Lay András
Re: Order column in the second table
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!