Adding New Column with default value.

[Gambhir Singh <gambhir.singh05@xxxxxxxxx>]

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