List:General Discussion« Previous MessageNext Message »
From:Antonio Fernández Pérez Date:June 12 2014 11:36am
Subject:Re: Order column in the second table
View as plain text  
​Hi Lay,

If I don't mistake, you can't eliminate "Using temporary" and "Using
filesort" because you are using an "order by". Try the explain again
removing order by and check the output.
When you use an order by, MySQL needs to use filesort and spends some time
sorting the result set. Also, create a temporary table with the rows
prevously. This is the reason.

Regards,

Antonio. ​

Thread
Order column in the second tableLay András12 Jun 2014
  • Re: Order column in the second tableAntonio Fernández Pérez12 Jun 2014
    • Re: Order column in the second tableLay András12 Jun 2014
      • Re: Order column in the second tableyoku ts.13 Jun 2014
        • Re: Order column in the second tableLay András13 Jun 2014