Hi @quahfamili ,
You might not find a single click solution to optimize the entire infrastructure because the performance issues might be of different reasons. If the increase in indexes is the main reason of performance degradation, you should re-look at the resource capacity. In a more general way,
Optimization starts from the data ingestion phase and continue until the search is executed. So define your data inputs in such a way that the indexing is proper and hence the data extraction.
Fine tune your data retention configurations according to your organization's requirements rather than depending on the default configuration. This will help you to reduce the amount of indexed data/storage.