Alter table in giant table

1

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.

    
asked by anonymous 30.08.2017 / 14:10

0 answers