SAP HANA: Can I apply a HINT at a database level

[Former Member]

I have queries that hit the SAP HANA SPS 11 bug. But I can bypass the problem with the HINT clause "WITH HINT( NO_USE_OLAP_PLAN )". In my application, queries are created by the system and it is impossible for a customer to append this HINT clause. Therefore the best way to solve this issue is to either apply the HINT at database/user level or turn off the OLAP engine.

However, I found that the HINT clause can only be applied to a specific query, either via individual SQL query statement or via alter system command by pinning a hint.

Can someone tell if SAP HANA allows to apply a HINT at database/user level or turn off the OLAP engine? If yes, how to do it?

Thanks.

[lbreddemann]

You seem to refer to a SAP BW on HANA setup.

For that, please see sap notes

https://launchpad.support.sap.com/#/notes/2280388

https://launchpad.support.sap.com/#/notes/2016000

https://launchpad.support.sap.com/#/notes/1931671

Generally speaking, it's not possible to completely switch off the OLAP engine as it is an integral part of SAP HANA and not just an additional funky feature.

[lbreddemann]

You seem to refer to a SAP BW on HANA setup.

For that, please see sap notes

https://launchpad.support.sap.com/#/notes/2280388

https://launchpad.support.sap.com/#/notes/2016000

https://launchpad.support.sap.com/#/notes/1931671

Generally speaking, it's not possible to completely switch off the OLAP engine as it is an integral part of SAP HANA and not just an additional funky feature.