Re: Mysql query performance
Posted by:
Bob Field
Date: August 31, 2006 01:04PM
First I'd organize the JOINs, using proper ANSI syntax.
SELECT *
FROM store_master AS s
JOIN item_storewise_sales AS i ON s.store_no = i.store_nbr
JOIN walmart_item_master AS w ON i.item_nbr = w.walmart_item_no
JOIN vendor_item_master AS v ON v.item_no = w.vendor_item_no
Subject
Written By
Posted
Re: Mysql query performance
August 31, 2006 01:04PM
September 03, 2006 04:29PM
September 03, 2006 04:42PM
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.