MySQL Forums
Forum List  »  Newbie

Re: Optimizing this join query
Posted by: Eric Hermann
Date: April 10, 2014 10:13AM

One strange optimization technique I tried yielded some pretty significant results.
I added this forced index: FORCE INDEX (index_products_on_sku_canonical) and it's showing significant performance increases (over 50%!!!!). It's weird - when I do an explain, the old query scans 5 times less rows but I guess it has something to do with

Using where; Using temporary; Using filesort in the fast query

VS

Using index condition; Using where; Using temporary; Using filesort

in the slow query.

Options: ReplyQuote


Subject
Written By
Posted
April 07, 2014 12:50PM
Re: Optimizing this join query
April 10, 2014 10:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.