If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

best way to add a new column with value

I have a compressed table (dimension) which has about 35M rows called CUST (customer). I got 15 tables, with an average of 100M rows, having a FK against the PK of the CUST table.

What I have to do is to add 2 new columns in my CUST table and they will never be null.

So my question is: which is the best way to add the 2 new columns.

Should I add the columns and then update the entire CUST table.
or
Should I create a new temp CUST table including the 2 new populated columns, disable the FK constraint realted to the CUST table, truncate the CUST table, insert into CUST the values from temp CUST and reenable the FK constraints?