I have a database with over 250,000 records which contain information relating to people who have taken out magazine subscriptions spanning decades. These are currently all in one table but there only around 5,500 active records - the others contain people who are no longer alive, have ceased their subscriptions, are no longer contactable or are otherwise 'inactive'.
My question: is there a best practice for handling this scenario? I'm wondering about moving the deliquent records to a separate table which is identical to the source table but maybe there's a better way?!