use add [column] AFTER [col_name] syntax to avoid table rebuild
When adding a column mid table and enforcing column order, it would be better to use the AFTER keyword to avoid a table rebuild. e.g.
alter table test_col2 add column d int after c;
8
votes
Chris Auckland
shared this idea