I have a short question: I have two ADSOs, where the first one has a higher granularity and the second one goes into more detail.
So all the data from the left one exist in the right one with lower granularity.
Although in theory Inner Join is faster than Left Outer Join, in this scenario it seems that Left Outer Join is faster after my performance analysis in both RSRT and Visualize plan in HANA Studio.
Could you please share your expertise regarding the use cases of Inner vs Left Outer Join? Is it by default Inner Join faster or does it depend on the case?