Skip to Content
avatar image
Former Member

Tools/Possible Options to Optimize HANA view

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
Add comment
10|10000 characters needed characters exceeded

  • 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

  • Get RSS Feed

0 Answers