Re: Optimizing this join query
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.
Subject
Written By
Posted
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.