The mf used two inputs of 89k (filtered) and 109k with one equality condition without null handling and had an output of 11M in almost two hours.
The execution plan was suboptimal because of a MJC.
I forced a better execution plan with hints and now the operation completes in 10 minutes.
I believe we can close the issue.