Re: Add column(s) to an existing table

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_at_il.proquest.com> wrote:
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l