If I have a large(200gb), medium width(300 bytes) table and need to add a column, we have always unloaded data, dropped and recreated the table then loaded data again to ensure performance.
What is the cost of using alter table on future queries?
What is the cost of using alter table on future queries?