Re: Add column(s) to an existing table

["Ethan Post" <post.ethan@xxxxxxxxx>]

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

Other related posts:

Add column(s) to an existing table

RE: Add column(s) to an existing table

Re: Add column(s) to an existing table

RE: Add column(s) to an existing table

RE: Add column(s) to an existing table

Re: Add column(s) to an existing table