Home » RDBMS Server » Performance Tuning » Help me tune the query (Oracle 9.0.0.2)
Help me tune the query [message #339042] Wed, 06 August 2008 11:17 Go to next message
thalladas
Messages: 16
Registered: August 2008
Junior Member
Hi Group,

I have query which is taking like 3 mins for retrieving one set of records:
SELECT product_number, batch, expiry_date
FROM dm.monthly_stock_balances@SMDM
WHERE year = v_year_in
AND month = v_month_in
FOR UPDATE OF expiry_date;

I tryed for like this
SELECT product_number, batch, expiry_date
FROM dm.monthly_stock_balances@SMDM
WHERE year = 2006
AND month = 11
FOR UPDATE OF expiry_date;
It took 3 mins runnin the above query...by this we can say ..for every month and year it will take around 3 mins...thats it bad performance..can anybody tell me how to tune the query for maximum performance.

Please let me know,if am not clear enough.
Thanks,
Re: Help me tune the query [message #339043 is a reply to message #339042] Wed, 06 August 2008 11:19 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

http://www.orafaq.com/forum/t/84315/74940/
which of the suggestions in URL above have you tried & what were the results?
Previous Topic: How gathering of stats/ analyze stats work?
Next Topic: need assist to delete histograms
Goto Forum:
  


Current Time: Thu Dec 08 02:25:19 CST 2016

Total time taken to generate the page: 0.10110 seconds