MySQL Forums
Forum List  »  Performance

Re: Another Using temporary; Using filesort performance problem
Posted by: Rick James
Date: December 08, 2015 08:52PM

INDEX(sch_year, sch_production_did, sch_id) might help.

Why did it pick the tables in that order? The optimizer, in the absence of a WHERE clause, tends to pick the smaller table to be first. As you found out, there can be other considerations that it is failing to consider.

How fast did it run without / with STRAIGHT_JOIN?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Another Using temporary; Using filesort performance problem
920
December 08, 2015 08:52PM


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.