Skip to Content
0

Looking for more details on HINT "NO_JOIN_THRU_AGGR"

Jun 02, 2017 at 08:27 PM

98

avatar image

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

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

1 Answer

Dinesh Anblazahan Jul 07, 2017 at 07:58 PM
0

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


9bka7.png (40.4 kB)
Share
10 |10000 characters needed characters left characters exceeded