Re: NOT IN and NOT EXIST

[Sameer Kumar <sameer.kumar@xxxxxxxxxx>]

On Sun, Jul 6, 2014 at 7:14 AM, Vik Fearing <vik.fearing@xxxxxxxxxx> 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

 

 

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).