Altering the data type of a column in a HUGE table. Performance issues
Asked 2012-06-12T11:30:44.577
8
I want to run this on my table:
ALTER TABLE table_name MODIFY col_name VARCHAR(255)
But my table is huge, it has more than 65M (65 million) rows. Now when I execute, it takes nearly 50mins to execute this command. Any better way to alter table?