After custome code remediate in hana. What is steps for code performance optimization in sap hana.

[former_member639649]

We have done custom code remediate and now how we want to code performance optimization in sap hana. I am new so please help me.

[raymond_giuseppi · Accepted solution]

First perform some search in available online documentation

• OSS : (KBA) HANA SQL Optimization
• Online help : HANA SQL Optimization

[former_member747869]

Caching is used widely in SAP HANA as a strategy to improve performance by re-using queried data rather than re-reading and processing the data every time it is requested. Administration and analysis tools for working with the Plan Cache for query optimization are available in the SAP HANA cockpit.

[former_member639649]

Thanx Sofia

[SriKrishna]

identify expensive SQLs and reports or transactions with high database time and then do a top down analysis to find out the related SAP application ( custom or standard) and fine tune it to reduce workload.

[former_member639649]

Ok...thank you Sri Krishna

[zsolt_zoldi]

Hello Gaurav,

To optimize SQL statements generated by custom code please refer to the following documents:
Statement Performance Analysis

SQL Tuning Guidelines

2000002 - FAQ: SAP HANA SQL Optimization

For a general performance optimization refer to the following KBA:
2000000 - FAQ: SAP HANA Performance Optimization

[former_member639649]

Thank you Zsolt Zoldi