Results 1 to 4 of 4

Thread: Updating 10 million rows

  1. #1
    Junior Member
    Join Date
    May 2007
    Answers
    1

    Updating 10 million rows

    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)


  2. #2
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Unhappy Re: Updating 10 million rows

    Quote Originally Posted by madivals View Post
    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)

    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


  3. #3
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    Re: Updating 10 million rows

    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


  4. #4
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: Updating 10 million rows

    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

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact