Re: Mysql sub query optimization
Unless the system has case sensitivity turned on. lcase() is redundant.
Without the results of Show Create Table, we're guessing. Type="index" often indicates that another index would improve performance. I'd srart with a covering c_category index on status(sort_order), a cc_category_description index on (language_id,name), and a product_to_category index on (product_id,category_id)
Subject
Written By
Posted
Re: Mysql sub query optimization
July 03, 2014 11:56AM
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.