Using index, using temporary, using filesort – how to fix this?
Well, the doc gives the exact reasons when “Using temporary” will appear: Temporary tables can be created under conditions such as these: If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join … Read more