There are bunch of HANA Views which are almost similar as per the business. The ask in hand is to optimize or reduce the HANA View in the present system. I am relatively new to the eco system. I am trying my best to consider the criteria for consolidation. The idea is to retire the redundant HANA views. Tools at my disposal is HANA Studio
Evaluation Criteria :
Complexity of calculation logic, Determine any dependent object modification as a result of consolidation, Dependent Objects, Data Volume and Performance, Data Model Alignment.
Where can i look out in the catalog table to mine the model details, i don't want to do manual mining but try to fetch from catalog table in System schema. Is there a better way to approach. Kindly guide.
Apologies for being verbose.