Wednesday, June 25, 2014

Make the table smaller for test and restore it back

Scenario:
There's a huge table with 40 million records or more and now for test purpose need limit the records to the latest 5 days records. After the test, need
restore the table.
Resolution:
Delete would be very, very slow. It may need 24 hours or even longer. The best way is to rename the table and create the new table.

No comments:

Post a Comment