Performance of Outerjoin in Composite Provider

Dear All,

In my composite provider I have Left outer joined 2 DSO with each around 6 million records. And when I call the composite provider in Analysis for Office the performance is very slow. The 2 DSO have n:m relationship.

Is there any general limit on the number of records and type of joins? ( ofcourse the performance also depends on the size and CPU of HANA DB)

Thanks in advance!

Best Regards, Vitali