I have a table with 20 million rows that is rebuilt from scratch daily. The process of populating the table and building the index on this table takes several hours. I would like to know if it's possible/wise to create this table and it's indexes under a temporary name, then simply drop the old one and rename the temporary to the real name; thereby minimizing the downtime of the table to only a few seconds. When I alter the table name do the indexes follow it to the new name or do they need to be rebuilt? Any downside in doing this? Thanks!
Start Free Trial
