MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: ORDER BY doesn't use index
Posted by: Toa Sty
Date: September 27, 2006 05:02AM

That's odd, I'd have expected an index on (status, req_id) to help but an index on (req_id, status) to have been ignored, but I'm glad you got it fixed anyway :)

Any chance you can post the explain plan? (just for curiousity's sake?)

Thanks,
Toasty

-----------------------------------------
email: 'toasty'*3 at gmail

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


Subject
Views
Written By
Posted
ORDER BY doesn't use index
12561
Frederic Giudicelli
September 13, 2006 12:32AM
Re: ORDER BY doesn't use index
5534
Toa Sty
September 13, 2006 02:00AM
Re: ORDER BY doesn't use index
4047
KimSeong Loh
September 13, 2006 02:36AM
Re: ORDER BY doesn't use index
3700
Frederic Giudicelli
September 27, 2006 03:39AM
Re: ORDER BY doesn't use index
3549
Toa Sty
September 27, 2006 05:02AM
Re: ORDER BY doesn't use index
3485
Frederic Giudicelli
September 30, 2006 05:53PM
Re: ORDER BY doesn't use index
3462
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.