improve performance for SAP HANA VIEW

[300221]

Hi Pro,

I have a very complex sap hana view, performance is bad, I created execution plan by planviz, and I figure out some point is the issue in the execution plan of planviz. but how can I find corresponding node in sap hana view:

[Jörg_Brandeis · Accepted solution]

Hi Bo,

there is not a 1:1 relation between nodes in the Calculation View and the nodes of the execution plan.

The information in the node could give you a hint which logical step is processed in the highlighted part. When you show at the mouseover text you can see a little more.

It looks like there is a CASE expression in a JOIN condition somehow. This could lead to slow execution. Sometimes it is possible to avoid a CASE by splitting a Node into multiple nodes with distinct records by some `WHERE` conditions. Then you could process (e.g. JOIN) them seperatly and combine them lateron with a UNION ALL.

Regards,

Jörg

[300221 · Accepted solution]

Thanks very much for the reply!