The query plan seems to be valid.
I've compared the query output resultsets:
- semi-join's resultset is a proper subset of non-semijoin's resultset
- whether a row is missing is a function of value of alias3.b: rows with values of 6,9,12,19 are missing. All others are present.
The query plan seems to be valid.
I've compared the query output resultsets:
- semi-join's resultset is a proper subset of non-semijoin's resultset
- whether a row is missing is a function of value of alias3.b: rows with values of 6,9,12,19 are missing. All others are present.