Re: NOT IN and NOT EXIST - Mailing list pgsql-general
On Sun, Jul 6, 2014 at 7:14 AM, Vik Fearing <vik.fearing@dalibo.com> wrote:
> NOT EXISTS translates to HASH ANTI JOIN and NOT IN translates to NOTIt will, hopefully in 9.5.
> (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?
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).
Attachment
pgsql-general by date: