I am trying to delete records in a batch and it's taking forever. there are 65 million rows in one table and I am deleting based on some condition and that table is joining with some other tables.

I came up with another idea.

1. First copy the data to flat file which we want to keep

2. Truncate the table

3. Import data from flat file to the table.

This way is much faster.

any suggestions guys. ?