List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:February 24 2012 3:20pm
Subject:Re: USING WHERE; USING TEMPORARY; USING filesort
View as plain text  
On Thu, Feb 23, 2012 at 5:50 PM, Daevid Vincent <daevid@stripped> 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
Thread
USING WHERE; USING TEMPORARY; USING filesortDaevid Vincent23 Feb
  • Re: USING WHERE; USING TEMPORARY; USING filesortJohan De Meersman24 Feb
  • Re: USING WHERE; USING TEMPORARY; USING filesortPerrin Harkins24 Feb