cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for more details on HINT "NO_JOIN_THRU_AGGR"

former_member440418
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member440418
Participant

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