NO way! Because downtime! Why do you think that I am taking all those extra measures or steps? The table has over 1 billion records 😎

I did not design this table / database, I am the new DBA. It is my responsibility to take care of the system though, that's what I am doing.

I pretty much know what I need to do. I was just asking to validate the overall steps.

The database is a MC one. I can't touch it! Plus is a very old hardware with serious IO bottleneck. Any activity on that table will make the table useless and trigger a downtime.