| 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 filesort | Daevid Vincent | 23 Feb |
| • Re: USING WHERE; USING TEMPORARY; USING filesort | Johan De Meersman | 24 Feb |
| • Re: USING WHERE; USING TEMPORARY; USING filesort | Perrin Harkins | 24 Feb |