Performance Optimization of Calculation Views

[michael_devine1]

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!

SAP HANA Enterprise Cloud SAP HANA, express edition 

Best Regards,

Vikram Kamvar

[michael_devine1]

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.

[Vitaliy-R]

Have you seen this Performance Guide?

https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-performance-guide-for...

Is it helpful?

Regards,
--Witalij

[Vikram_Kamvar1]

Thanks Vitaliy, I will go through this guide