Re: Add column(s) to an existing table

From: "Ethan Post" <post.ethan@xxxxxxxxx>
To: Mark.Bobak@xxxxxxxxxxxxxxx
Date: Mon, 7 Aug 2006 11:42:05 -0500

I recall some tests I did in the past and I think that adding a new column
to a large table with a default value utilizes significantly more redo than
adding the column with null, running an update to set the default value,
then altering to set default value for future rows. You would want to test
that of course.

Also when dropping columns from large tables you may want to consider using
the CHECKPOINT interval, I don't think this can be used if you have set the
column as UNUSED and try to do it later.

All information is going off memory, so results may vary :)

- Ethan

On 8/1/06, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:

References:

RE: Add column(s) to an existing table
From: Roger Xu

RE: Add column(s) to an existing table
From: Bobak, Mark

Re: Add column(s) to an existing table

Other related posts: