MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Desperate: BETWEEN and ORDER BY on different columns
Posted by: Joachim Berger
Date: September 05, 2011 01:03AM

Hi Rick,

thanks for the answer. The problem with the last example (the one with the 'bulky' fields) is that it's still using filesort for the result table (<derived2>).

I don't know if it's better to indeed have a filesort here, or just have a less selective index on just (sex, rnd) and do the "WHERE birthdate..." part in the outer query. In this case, no filesort is being used, but more rows are returned of course.

Any suggestions?

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


Subject
Views
Written By
Posted
Desperate: BETWEEN and ORDER BY on different columns
5613
Joachim Berger
September 01, 2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1383
Jørgen Løland
September 01, 2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1141
Joachim Berger
September 01, 2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1475
Jørgen Løland
September 01, 2011 06:12AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1411
Rick James
September 05, 2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1225
Joachim Berger
September 05, 2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1386
Rick James
September 06, 2011 07:03PM


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.