One of our production table contains about 1 billion records.
There is a need to remove one column and add 2 new columns, then update them.
Should I create alter scripts for this and update the table with new values?
or create a new table and load the data from old to new, drop the 1st table and rename the 2nd one.
What should be the approach?
View Complete Post