I need to perform an alter table operation on multiple fields in a table, and this table has more than a billion lines. One operation for each field takes approximately 2 hours and now it imagines for several fields.
In development environment I would run an operation for each field at a time and now to run a script that will affect all fields at once in Production will take more than 15 hours, according to my estimate.
Is there a way to optimize to run script faster?
This work is precisely to reduce the size of the table that is becoming unbearable.