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