MySQL Forums
Forum List  »  Optimizer & Parser

Re: Need to optimise complex query
Posted by: Ben Sebborn
Date: April 30, 2007 05:00AM

I presume it's the GROUP BY and GROU_CONCAT that are causing the temporary disk usage?

It was suggested that I put all the Ent.Citycode strings into a temporary table, then do an inner join to this table, rather than using Ent.Citycode IN ('xxx','xxx') etc

Do you think this would be beneficial or take just as long? Any other suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
3168
April 29, 2007 04:13PM
1979
April 29, 2007 10:21PM
Re: Need to optimise complex query
2038
April 30, 2007 05:00AM
2095
April 30, 2007 08:36PM


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.