SAP MII - native HANA SQL Queries performance

[janusz_gren]

Dear all,

our team was recently confronted with a few requests to increase the MII application performance in a few areas and while analyzing the performance losses we have encountered an interesting issue.

All of our Database requests are Native SQL using the MII SQLQuery actions against the HANA database. Some of the requests do get quite big as our system is not only used for data entry but also for quite complex data analysis across multiple organization units. We have discovered that for big queries the query compilation time exceeds the query execution time (similar example can be found in the SAP note 0002375200). The proposed soultion from the SAP note was to use bind variables instead of just passing the values directly to the queries.

Is there a way to achieve this using the SQLQuery actions but without pushing down every single select statement to a stored procedure?

Thanks in advance for any ideas.

If you need more information do not hesitate to contact me.

Thanks in advance!

Janusz