OraFAQ Forum: Performance Tuning » Updating a BIG table

Home » RDBMS Server » Performance Tuning » Updating a BIG table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Updating a BIG table [message #218369]

Wed, 07 February 2007 21:10

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

Report message to a moderator

Re: Updating a BIG table [message #218371 is a reply to message #218369]

Wed, 07 February 2007 21:25

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Take a look here for ideas.

Ross Leishman

Report message to a moderator

Re: Updating a BIG table [message #218597 is a reply to message #218371]

Thu, 08 February 2007 22:00

gulabo
Messages: 5
Registered: February 2007
Location: FL

Junior Member

Thanks. I will try it out.

Report message to a moderator

Re: Updating a BIG table [message #218989 is a reply to message #218369]

Mon, 12 February 2007 07:02

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

Report message to a moderator

Re: Updating a BIG table [message #219701 is a reply to message #218989]

Thu, 15 February 2007 10:33

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

Report message to a moderator

Previous Topic:	Data file init write
Next Topic:	straight sql vs procedural ASAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 11:08:09 CST 2024