On Thu, Feb 23, 2012 at 5:50 PM, Daevid Vincent <dae...@daevid.com> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql