|
|
|
|
Re: Adding column to the table which have the huge data [message #665817 is a reply to message #665808] |
Fri, 22 September 2017 07:51 |
|
Revathi.orafaq
Messages: 21 Registered: September 2017
|
Junior Member |
|
|
As per the Forum suggestions we applied multiple solutions .
One of the best solution is adding NOT NULL constraint to the add the column with some DEFAULT value
(If it is applicable as per the business).
Previously most the DEFAULT value alters doesn't have NOT NULL Constraint for Partitioned table.
After adding the NOT NULL we saw a lot time difference to execute.
For some tables applied the Multi column adding logic but we didn't go for PARALLEL HINT .
Once again thanks to FORUM
Thanks
Revathi.T
|
|
|