Re: Need help performing large updates...
From: Bob Poortinga <bobp_at_tsc.com>
Date: 1996/04/18
Message-ID: <3176E073.5417_at_tsc.com>#1/1
Date: 1996/04/18
Message-ID: <3176E073.5417_at_tsc.com>#1/1
One thing to remember about large updates: Never update a column that is part of an index. Drop the index first, do the update, and then rebuild the index. It's faster, uses much less rollback space, and has less redo log activity.
-- Bob Poortinga (mailto:bobp_at_tsc.com http://www.tsc.com/~bobp/) Technology Service Corp. (http://www.tsc.com/) Bloomington, Indiana USAReceived on Thu Apr 18 1996 - 00:00:00 CEST