Skip to Content
0

Tools/Possible Options to Optimize HANA view

Jan 11, 2017 at 04:14 PM

44

avatar image
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
10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers