Re: What's the fastest way to UPDATE?

Will Hartung - Master Rallyeist (villy@uunet.uu.net) wrote: : : Hi all! : : We've got a process that basically needs to update every row in a 2 : : million row table. The row size is ~260 bytes, so it's not huge. <EXTREMELY LARGE SNIP> My 2 cents worth: declare your cursor with the "for update" clause on the fields you need to update. As was posted before, back up first, turn logging off, go for it. -- gburnore@netcom.com ------------------------------------------------------------------------------- How you look depends on where you go. -------------------------------------------------------------------------------