Skip to Content
0

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

Nov 14, 2016 at 04:13 PM

65

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lars Breddemann
Nov 15, 2016 at 03:46 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Lars Breddemann
Nov 15, 2016 at 03:46 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded