Re: ORDER BY doesn't use index
explain SELECT req_id FROM requester WHERE status='1' ORDER BY req_id ASC LIMIT 0,90;
+----+-------------+-----------+------+---------------+--------+---------+-------+--------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+---------------+--------+---------+-------+--------+-----------------------------+
| 1 | SIMPLE | requester | ref | status | status | 4 | const | 538427 | Using where; Using filesort |
+----+-------------+-----------+------+---------------+--------+---------+-------+--------+-----------------------------+
Subject
Views
Written By
Posted
12269
September 13, 2006 12:32AM
5416
September 13, 2006 02:00AM
3931
September 13, 2006 02:36AM
3565
September 27, 2006 03:39AM
3437
September 27, 2006 05:02AM
Re: ORDER BY doesn't use index
3346
September 30, 2006 05:53PM
3338
October 03, 2006 02:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.