If it’s an ordinary transactional database, you can go for a data warehousing solution for your reporting purposes.
Data warehouses are usually more efficient in these type of situations.
solved Database growth – How to handle with big tables [closed]