I think useless is a heavy word for this.
We have a database with 500GB, and most of it's information is only there if we MAYBE need to use them. it's a big database with credit card information and until now, we've never had the need to select them ( the table has 500millions rows ).
this database is growing daily and I would like to know what is the best approach of this?
I can't think in something smart. I don't think a backup and delete all rows will be the best approach. then if we need those rows, we restore the backup.
Is there something like partitioning to be used here? there are 2 tables with this "problem". how can I get rid of these 2 tables, but maintaining these tables secured?