Re: NOT IN Doesn't use Anti Joins?

On Thu, Dec 17, 2009 at 9:02 AM, Rod Taylor <rod(dot)taylor(at)gmail(dot)com> wrote:
> Is there a reason why the NOT IN plan could not use Anti-Joins when
> the column being compared against is guaranteed to be NOT NULL? Too
> much planner overhead to determine nullness of the column?

I doubt it. I think it's just a question of round tuits. I think Tom
hasn't felt it worth the effort since you can work around it by
rewriting the query, and nobody else has bothered to work up a patch.
If you feel like working on it, I think it would be a nice
improvement.

...Robert