Tools/Possible Options to Optimize HANA view

[Former Member]

Hello All,

We have HANA views which are being built on the BW objects (ODS) having the same structure of BW report to expose to third party application. Is there any way to check if these views are optimized or not?

We are already using 'Explain Plan' and 'Visalization Plan' to track memory utilization and expensive joins in SQL statements from reporting tools (qlikview/MSTR) which consume data via these views but is this also applicable for HANA views? If yes, then how?

Thanks

Abhishek Shanbhogue

[Former Member]

We did setup a process to test the HANA views before they are deployed in production by running some simple tests with Explain Plan, Plan Visualizer and executing some select statements for most frequently accessed fields over different time intervals and compare them with baseline