MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: ORDER BY doesn't use index
Posted by: Frederic Giudicelli
Date: September 27, 2006 03:39AM

USE INDEX(req_id) didn't do anything.
What turned out to be the best solution is INDEX(req_is,status).

Thanks for your help.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ORDER BY doesn't use index
12248
Frederic Giudicelli
September 13, 2006 12:32AM
Re: ORDER BY doesn't use index
5401
Toa Sty
September 13, 2006 02:00AM
Re: ORDER BY doesn't use index
3918
KimSeong Loh
September 13, 2006 02:36AM
Re: ORDER BY doesn't use index
3553
Frederic Giudicelli
September 27, 2006 03:39AM
Re: ORDER BY doesn't use index
3431
Toa Sty
September 27, 2006 05:02AM
Re: ORDER BY doesn't use index
3339
Frederic Giudicelli
September 30, 2006 05:53PM
Re: ORDER BY doesn't use index
3329
Toa Sty
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.