Query - delay 20 segs
Hi people,
I have 2 tables "sector" (sector_id, expired, updatetime) and "product" (product_id, sector_id, name, price, currency) and for each have 80000 rows.
I'm doing the follow sql instruction:
select * from sector, product where
sector.sector_id=product.sector_id and
sector.expired='0' and
sector.sector_id!='365727' and
product.price*product.currency>'658997000' and
product.price*product.currency<'659003000'
order by sector.updatetime
desc limit 5;
This sql instruction took 20 seconds... Could you help me to improve its performance?
Thanks,
Takemura.
Subject
Views
Written By
Posted
Query - delay 20 segs
4931
August 04, 2008 06:25AM
2461
August 04, 2008 06:26AM
2454
August 31, 2008 11:31PM
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.