urgent reply please
while iam trying to update one column from other table is taking too much of time. following is the command iam using
structru of table1
and table1 has approx 4 lakhs records.
stru of table2
table 2 has 12lakhs records approx
update table t set t.col1=(select sum(amount) from table where acno=t.acno and month='01-jan-2008')
for running this query its taking hours together and not responding
please help me to immediate update (iam using oracle 10g/9i)
How many rows do you have in each table?
Are your statistics up-to-date?
Please post Explain Plan.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
1st table 1lakh 2nd table 12 lakhs
firstly lakhs mean nothing to most people
secondly why not answer the question put to you?
Click Here to Expand Forum to Full Width