-
urgent reply please
hi
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
acno,col1,col2,col3,col4,col5
and table1 has approx 4 lakhs records.
stru of table2
acno,month,amount
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)
advance thanks
-
How many rows do you have in each table?
Are your statistics up-to-date?
Please post Explain Plan.
-
1st table 1lakh 2nd table 12 lakhs
-
firstly lakhs mean nothing to most people
secondly why not answer the question put to you?