Re: Outer Joins and IN / NOT IN
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 3 Mar 2017 11:46:35 +0300
Message-ID: <CAOVevU5=b6Ynu5f0cpvt8BR-uf8BnBCsJwhsrZzNdhvgkCohxw_at_mail.gmail.com>
Date: Fri, 3 Mar 2017 11:46:35 +0300
Message-ID: <CAOVevU5=b6Ynu5f0cpvt8BR-uf8BnBCsJwhsrZzNdhvgkCohxw_at_mail.gmail.com>
Hi Hemant,
No, at least full outer join, because it could be executed as native full outer join operation, and you can't get this operation using in/not in and native oracle sql(+).
Best regards,
Sayan Malakshinov
http://orasql.org
On Mar 3, 2017 09:42, "Hemant K Chitale" <hemantkchitale_at_gmail.com> wrote:
> Is there truth to the belief that LEFT and FULL Outer Joins should
> (always) be rewritten for performance ? I don't have the tables and SQLs
> so this was just an exploratory talk. My point is that we should write what
> seems obvious and is easy to understand rather than use convoluted
> subqueries.
>
>
> Hemant K Chitale
> Sent from my smartphone
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 03 2017 - 09:46:35 CET