| Help me tune the query [message #339042] |
Wed, 06 August 2008 11:17  |
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,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
