I have a table that stores some audit information and currently has 25 million records. There is a process that inserts to this table every 30 minutes. This is historical data and is not used for any processing.
Since this table already has huge number of records so these 30 minutes inserts are taking considerable long time to complete.
According to me I should archive this huge table and only have a day or so data depending on the business conditions and move rest of the data to a archival table.
One possible strategy that I thought was renaming the existing table to something else and creating a new table with the same name as the old one. Can somebody comment on this strategy or suggest a better solution?