Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 15, 2016 at 03:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2016 at 03:46 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded