On Sun, Jul 6, 2014 at 7:14 AM, Vik Fearing <vik.fear...@dalibo.com> wrote:
> > NOT EXISTS translates to HASH ANTI JOIN and NOT IN translates to NOT > > (HASHED) operation. > > > > Given that the columns used in NOT IN clause (for outer as well as > > inner) are NOT NULL, should not it translate a NOT IN plan similar to > > NOT EXISTS plan? > > It will, hopefully in 9.5. > > https://commitfest.postgresql.org/action/patch_view?id=1487 Cool! Will be looking forward to it! But seems a long way from now... Best Regards, *Sameer Kumar | Database Consultant* *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com *[image: icons]* [image: Email patch] <http://www.ashnik.com/> This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).
