I have been using this database for a few years now. It is getting too big. I would like to delete database from earlier years. I should have done that at the end of fiscal year (Dec 31) but I forgot.
Now, the problem is not all tables have Timestamp. I can’t use WHERE DATE < XXXXXX.
If your using SQL it should make no difference to performance, where you having issues?
Pretty much no is the answer, you cannot selectively delete transactions for obvious reasons.
You can clear all transactions with database tools.
That type of storage can be easily offloaded though, to a nas or cloud storage…
Old transactions should have limited effect on the actual SQL performance.