Re: Mysql query performance

[Veena Sarolkar]

Hi,

Following query takes 15-22 seconds. I have also given , Explain query results below.

query using JOIN operation (Takes 15 - 22 seconds) . This returns 59017 records
JOIN QUERY :
select * from item_storewise_sales i, walmart_item_master w, store_master s ,vendor_item_master v where i.item_nbr=w.walmart_item_no and s.store_no=i.store_nbr and v.item_no=w.vendor_item_no


EXPLAIN RESULT :
id select_type table type possible_keys key key_len ref rows Extra
------------------------------------------------------------------------------------------------------------------------------
1 SIMPLE w ALL PRIMARY 27
1 SIMPLE i ref PRIMARY PRIMARY 50 w.walmart_item_no 6148 Using where
1 SIMPLE s eq_ref PRIMARY PRIMARY 8 i.store_nbr 1
1 SIMPLE v eq_ref PRIMARY PRIMARY 20 w.vendor_item_no 1


Thanks,
Veena