Delete large volume of data records - Sybase
843859Feb 7 2008 — edited Nov 20 2014I have a Sybase database that has 8 million+ records. I need to reduce the size of the records within the DB to around 1 million, approx 12 months of data.
I was thinking of deleting 50,000 records each time, then commit the changes. (To prevent the transaction logs from overflowing), within a loop statement.
Has anyone ever done something like this before and could provide some additional ideas on how best to do this.
Thanks!