optmizing ORDER BY in MySQL

Posted by onTuesday, March 24. 2009

A few days back we were trying to optimize a sql query that was using an ORDER BY clause. When we ran an EXPLAIN on the query, we saw that the query was Using filesort ...