Whats causes an "Outer (RESEGMENT)(LOCAL ROUND ROBIN)" during a JOIN?
I have a query where the plan flip/flops between "Inner (RESEGMENT)" and "Outer (RESEGMENT)(LOCAL ROUND ROBIN)" by swapping the INNER / OUTER parts of the JOIN.
The one part has a fixed row count of 70k while the other part varies. The tipping point is not based on row count (alone) as it is somewhere between 5k and 6k rows on the variable part. (Below this point the variable part is the INNER.)
What would be the benefit of the OUTER (RESEGMENT) plan? Is there a way to turn it off?