On 6/29/07, Rich Brant <[EMAIL PROTECTED]> wrote:
Hello all. I'm looking for help with the query below. Is there anyway to prevent the temporary and filesort?
The filesort is caused by either the ORDER BY or the GROUP BY. There are sections in the manual about how to get it to use indexes for these. That's the only way to prevent the filesort. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]