MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Desperate: BETWEEN and ORDER BY on different columns
Posted by: Rick James
Date: September 06, 2011 07:03PM

Myth: Filesort is terrible.
Fact: Filesort is necessary for some queries.
Fact: Filesort does not necessarily involve touching the disk.

Use the elapsed time of the query to judge whether it is "good". "Filesort" (etc) are merely clues.

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


Subject
Views
Written By
Posted
Desperate: BETWEEN and ORDER BY on different columns
5717
Joachim Berger
September 01, 2011 02:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1449
Jørgen Løland
September 01, 2011 05:32AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1178
Joachim Berger
September 01, 2011 05:35AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1532
Jørgen Løland
September 01, 2011 06:12AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1446
Rick James
September 05, 2011 12:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1275
Joachim Berger
September 05, 2011 01:03AM
Re: Desperate: BETWEEN and ORDER BY on different columns
1432
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.