Home » RDBMS Server » Performance Tuning » Updating a BIG table
Updating a BIG table [message #218369] Wed, 07 February 2007 21:10 Go to next message
gulabo
Messages: 5
Registered: February 2007
Location: FL
Junior Member

Hi!

I am working on updating a 1 billion row table. The requirement is to update a flag field according to the business requirement.

Can someone suggest a good way (performance wise) to update the flag. Once again, the table has '1 billion' rows!

Thanks,

-SV
Re: Updating a BIG table [message #218371 is a reply to message #218369] Wed, 07 February 2007 21:25 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look here for ideas.

Ross Leishman
Re: Updating a BIG table [message #218597 is a reply to message #218371] Thu, 08 February 2007 22:00 Go to previous messageGo to next message
gulabo
Messages: 5
Registered: February 2007
Location: FL
Junior Member

Thanks. I will try it out.
Re: Updating a BIG table [message #218989 is a reply to message #218369] Mon, 12 February 2007 07:02 Go to previous messageGo to next message
cbruhn2
Messages: 41
Registered: January 2007
Member
I would like to recommend
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6407993912330
In short the recommendations is don't update !

best regards.
Carl Bruhn
Re: Updating a BIG table [message #219701 is a reply to message #218989] Thu, 15 February 2007 10:33 Go to previous message
gulabo
Messages: 5
Registered: February 2007
Location: FL
Junior Member

thanks, you are right... i will be not be updating as it will blow up the temp space. i am doing it by creating another table with the same schema and will make the changes while inserting into it.

-SV
Previous Topic: Data file init write
Next Topic: straight sql vs procedural ASAP
Goto Forum:
  


Current Time: Mon Dec 05 15:10:54 CST 2016

Total time taken to generate the page: 0.08073 seconds