I have a table having 10 million rows. I need to update one column, last time it is took around 8-10 hours, Is there any other way, so that the process can be completed in 3-4 hours?. (Oracle 9i, W2k platform)
I have a table having 10 million rows. I need to update one column, last time it is took around 8-10 hours, Is there any other way, so that the process can be completed in 3-4 hours?. (Oracle 9i, W2k platform)
Re: Updating 10 million rows
Originally Posted by madivals
hi madi
the effort can be reduced to 3-4 hours but there is only one way
that you group your task according to common entries and update them one by one....sorry i was joking..
please if you could post a screen shot of your table structures and the task listed then there is some thing whcih can be planned for these...else you can add a column and fill in the new entries and dropping the old column
i think that should work....
i will do some research an then will let you know
thanks for posting such question
If there are indexes on the table then first drop them and then update ur table with new column.After the update of the table recreate the indexes.
This will reduce lots of time.
Reeta
There are not many options to help reduce the updating time.
You may try applying the command multiple times by updating the column for a particular group of records each time.
I think this may be faster because the database will not have to update all the records at the same time. This saves some memory (RAM) space and utilizes the same for other operations.
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.
-sutnarcha-
Posting Permissions
Reply With Quote