Adding column is slow

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: Thu, 22 Aug 2002 13:22:24 +0200
Message-ID: <3d64c91c$0$43947$edfadb0f@dspool01.news.tele.dk>

Hi,

System(s) 8.0.5 and 8.1.7 SE

Adding a new column to a large table is taking hours. Its part of an update that will be run at many customers. The table will contain approx 100M rows. The table has 5 number fields and a date field. A new 'number(1) default 0' is beeing added
Assuming the update will run as the only user connected what could be done to speed up things?
Will any of the following help: Disabling triggers? Disabling constraints? Dropping indexes and rebuilding?

Also how do I calculate the how much rollback space is needed?

TIA
Peter Laursen Received on Thu Aug 22 2002 - 06:22:24 CDT