Table has 30 million rows, 11 GB in size, I need to alter one column from INT into BIGINT. I need to keep downtime to 10 min max.
Presently there are some values in that column, mostly zeroes, these values are no longer needed.
If I update the column to be all nulls before altering will my alter statement run fast? in other words, does the content of the column affect the speed of alter operation?