From: Perrin Harkins Date: February 24 2012 3:20pm Subject: Re: USING WHERE; USING TEMPORARY; USING filesort List-Archive: http://lists.mysql.com/mysql/226851 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Feb 23, 2012 at 5:50 PM, Daevid Vincent wrote: > Anyone have any thoughts on how I might optimize this query? As always, it's all about the indexes. The index it chose on your main table looks pretty weak. You probably should move those non-joining columns out of your join condition in case their location is influencing the plan, and try experimenting with multi-column indexes. - Perrin