MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Desperate: BETWEEN and ORDER BY on different columns
1099
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.