MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Long execution time despite LIMIT 3
Posted by: Joachim Berger
Date: June 22, 2011 11:45PM

How come I don't need to include ID in the index, because of the ORDER BY id DESC..., like:

INDEX(thread,id_user_r,del_r,id)
INDEX(thread,id_user_s,del_s,id).

Howver, the EXPLAIN doesn't show a difference.

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


Subject
Views
Written By
Posted
Long execution time despite LIMIT 3
2539
Joachim Berger
June 19, 2011 12:47PM
Re: Long execution time despite LIMIT 3
900
Joachim Berger
June 19, 2011 12:54PM
Re: Long execution time despite LIMIT 3
1042
Rick James
June 20, 2011 06:33PM
Re: Long execution time despite LIMIT 3
1058
Joachim Berger
June 20, 2011 11:44PM
Re: Long execution time despite LIMIT 3
998
Joachim Berger
June 21, 2011 02:06AM
Re: Long execution time despite LIMIT 3
1069
Rick James
June 21, 2011 07:23AM
Re: Long execution time despite LIMIT 3
857
Joachim Berger
June 21, 2011 07:28AM
Re: Long execution time despite LIMIT 3
1001
Joachim Berger
June 21, 2011 10:33AM
Re: Long execution time despite LIMIT 3
1052
Rick James
June 21, 2011 10:08PM
Re: Long execution time despite LIMIT 3
1425
Joachim Berger
June 22, 2011 12:33AM
Re: Long execution time despite LIMIT 3
981
Rick James
June 22, 2011 07:26PM
Re: Long execution time despite LIMIT 3
878
Joachim Berger
June 22, 2011 11:45PM
Re: Long execution time despite LIMIT 3
988
Rick James
June 23, 2011 08:53AM
Re: Long execution time despite LIMIT 3
1000
Joachim Berger
June 24, 2011 02:51AM


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.