MySQL Forums
Forum List  »  Optimizer & Parser

Re: Need help with getting rid of filesort
Posted by: Peter Brawley
Date: June 24, 2022 09:59AM

Did you read https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html ?

For specific help with your query, we'll need to see the MySQL version, the result of Show Create Table for the table in question, and the result of Explain Analyze on the query.



Edited 1 time(s). Last edit at 06/24/2022 09:59AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Need help with getting rid of filesort
143
June 24, 2022 09:59AM


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.