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@xxxxxxxxx> 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
