vidya_pande (3/17/2010)
I have simple solution for you.Copy 5 Million records to another dummy or staging table.
Truncate the original table.
And then copy 5 Million rows from Dummy table to original table.
If you do not have partitions created on table this is the fastest way.
😉
Simple, yes. But not always practical on a production system.
Also, remember that foreign key constraints will need to be dropped, indexes re-created etc etc etc
Good idea, though.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi