Question Re: Performance Optimization of Calculation Views in Technology Q&A

Performance Optimization of Calculation Views

Vikram_Kamvar1 — Wed, 18 Sep 2024 21:41:57 GMT

Hello SAP Community,

When working with SAP HANA Calculation Views perfromance optimization, how do you figure out where the performance is slow or what is causing it?

I am currently learning on this concept but always my question is, how do we actually know where the performance is poor? On what basis can we say that the performance of a calculation view is bad?

Thanks in advance for your suggestions!

Best Regards,

Vikram Kamvar

Re: Performance Optimization of Calculation Views

michael_devine1 — Thu, 19 Sep 2024 08:26:02 GMT

Start at the bottom nodes. Data preview each node and check the performance. Then work up though the levels of the view and see where exactly the performance starts to deteriorate. Then you can copy the SQL statement for the node and look for potential improvements. Good/bad response times are relevant to the design of the view and the amount of data being consumed.

Re: Performance Optimization of Calculation Views

Vitaliy-R — Thu, 19 Sep 2024 12:44:50 GMT

Have you seen this Performance Guide?

https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-performance-guide-for-developers/optimization-features-in-calculation-views

Is it helpful?

Regards,
--Witalij

Re: Performance Optimization of Calculation Views

Vikram_Kamvar1 — Fri, 20 Sep 2024 14:26:53 GMT

Thanks Vitaliy, I will go through this guide