Skip to Content
0
Former Member
May 17, 2018 at 04:49 AM

HANA Optimizer function

578 Views Last edit May 17, 2018 at 04:49 AM 2 rev

HI,

I'm using SAP HANA DB.

There are some problems with user's query. Sometimes it makes OOM on HANA DB.

So, i'm thinking of a function that blocks user's query(which may cause OOM) before executing query on HANADB .

If SAP HANA optimizer can estimate cost of query user asked, i think that it may possible to forecast that the query may cause OOM or Not.

so if SAP HANA optimizer have that kind of function, please tell me how to use it.

(If not, also please tell me that it's impossible)

thank you for your help

regards, Tae