I got request from app Team to add new column to a table with following specifications
1. With Not Null Constraint
2. With Default value 0
Row Count - 50 Billion
Please help me to understand
a. DDL statement (alter table add column) will be followed by the DML statement (Update)....Am I correct ?
b. What would be size of the Table (I assuming it will be doubled)
c. What is the best approach for this kind of activity.
Thanks & Regards
Gambhir Singh