My resolution when adding a column in a huge table (records/structure wise)is to split it into two process. 1st ALTER the table to add the column and then 2nd, UPDATE the table to populate the default value. And let the developer to write a TRIGGER to include the default value everytime there is a new record inserted. But that just me