In a project, we need to frequently
ALTER the tables to delete or add columns. I wonder if this weakens the database performance in long term. If it has a considerable negative impact, what is the approach to keep the database healthy and efficient?
I was thinking of the following approaches:
OPTIMIZE the tables
CREATE a new database with the final architecture, and INSERT the entire data
The database is mysql(5.5) with InnoDB.