Julian> Vladimir said he *expected* Oracle would implement (3-valued) NOT IN efficiently. (Back in the day, when I was at Oracle, they certainly did not.) Does anyone have any evidence that they do?
Well, Oracle has "null aware" joins since Oracle 11g which is more than 10 years old. I have not tested the actual performance of the `null-aware join`, however, it would be extremely surprising, if `null-aware join` was less efficient than "manually crafted aggregate + join + join + whatever". That is why I think it is important to be able to generate regular "not in" plans. Vladimir
