On Tue, 2006-10-17 at 09:26 -0700, Robert DiFalco wrote: > I have an unavoidable filesort in a very large query. Can someone point > me to references for optimizing filesort? I'm assuming this is going to > be changes to my.ini or the hardware.
Well, one method to *eliminate* "Using filesort" is to either use a covering index, or take advantage of InnoDB's clustered organization (which has an implicit sort of data records on the primary key). Can you show us an example of the query in question, using an EXPLAIN? Cheers, Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]