Delete records from CSE_ASSETS_B base table

We have a question from our client on the purging on data from base table based on certain criteria.

Background: We have huge volume if data (in millions) for IB. As client use the application, the volume of records will keep increasing and there would be performance issue. Hence client want to explore a data purge functionality based on last update date or end date - if the records have not been used on a subscription for last 5 years or so, the records can be deleted from the base table. Thus reducing the count and there could be better performance issue.