MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: avoiding temp/filesort for order by on child table
Posted by: Peter Brawley
Date: January 11, 2021 12:03PM

Obviously MySQL can't index across two tables, and materialising the join would cost performance ... beyond that without the DDL one can only guess, but there's obviously enough RAM for the filesort to happen in RAM so I doubt the filesort will significantly slow down your query.

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


Subject
Written By
Posted
avoiding temp/filesort for order by on child table
Matthew Lenz
January 11, 2021 09:52AM
Re: avoiding temp/filesort for order by on child table
Peter Brawley
January 11, 2021 10:18AM
Re: avoiding temp/filesort for order by on child table
Matthew Lenz
January 11, 2021 10:58AM
Re: avoiding temp/filesort for order by on child table
Peter Brawley
January 11, 2021 12:03PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.