Re: outer join between parent-child, not null and FK constraints
From: amonte <ax.mount_at_gmail.com>
Date: Fri, 25 Jan 2013 00:15:39 +0100
Message-ID: <CABV7K9uxF4UimnKJ2zH4M1mx4URPu+YWBFi6LZCyxNf23bDzfw_at_mail.gmail.com>
Hi Rich
your query returns all rows in dept
Date: Fri, 25 Jan 2013 00:15:39 +0100
Message-ID: <CABV7K9uxF4UimnKJ2zH4M1mx4URPu+YWBFi6LZCyxNf23bDzfw_at_mail.gmail.com>
Hi Rich
your query returns all rows in dept
why am I thinking oracle should be smart enough to detect this? it is because CBO can now do join elimination and the example I posted it is not difficult to implement in CBO no?
Thanks!
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 00:15:39 CET