Luc Vlaming writes:
> Given the testcase we see that the outer semi join tries to join the
> outer with the inner table id columns, even though the middle table id
> column is also there. Is this expected behavior?
I don't see anything greatly wrong with it. The planner has concluded
that _inn
Hi,
At a customer we came across a curious plan (see attached testcase).
Given the testcase we see that the outer semi join tries to join the
outer with the inner table id columns, even though the middle table id
column is also there. Is this expected behavior?
The reason i'm asking is two-f