skip to Main Content

MySQL explain shows that main table's indexes are not used at production server – Oscommerce

I am trying to optimize the following modified MySQL query from OsCommerce: select distinct p.products_id, pd.products_name, m.manufacturers_name, s.specials_new_products_price from products p inner join products_description pd on p.products_id = pd.products_id inner join products_to_categories p2c on p.products_id = p2c.products_id left join manufacturers…

VIEW QUESTION
Back To Top
Search