Skip to Content

Looking for more details on HINT "NO_JOIN_THRU_AGGR"

Hi,

We are forced to use HINT "NO_JOIN_THRU_AGGR" in our SQL. I am trying to find some information on the HINT "NO_JOIN_THRU_AGGR" but no luck I tried searching SAP notes and SCN but I am not getting any information other than

"Pushdown of joins through aggregations". What I could infer from the name description is the HINT decides when the join should happen is it before aggregation or after aggregation .

But my fear is before using this HINT in our SQL we have to be double sure my understanding is right because Join before Aggregation and after Aggregation will give different output.

It will be great help if someone could explain me more about this hint with an example.

Thanks & Regards

A.Dinesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 07, 2017 at 07:58 PM

    Hi ,

    I found the answer myself from "HANA trouble shooting and Performance Analysis Guide". and the answer is below:

    But I am wondering how system can take a call on aggregation sequence it has to be controlled by the data modeler because Join before aggregation and after aggregation will have different result set based on the data .

    Thanks & Regards

    A.Dinesh

    Add comment
    10|10000 characters needed characters exceeded