Re: outer join between parent-child, not null and FK constraints
From: amonte <ax.mount_at_gmail.com>
Date: Fri, 25 Jan 2013 00:13:31 +0100
Message-ID: <CABV7K9t=jnhoeQoUnTZoT0WkvGkg6MunzzWhtST+iY6jkepL1g_at_mail.gmail.com>
Hi David
I added the constraints already before post the mail!
Date: Fri, 25 Jan 2013 00:13:31 +0100
Message-ID: <CABV7K9t=jnhoeQoUnTZoT0WkvGkg6MunzzWhtST+iY6jkepL1g_at_mail.gmail.com>
Hi David
I added the constraints already before post the mail!
In your example it did Merge Join Outer, why you say it is smart enough to not outer join?
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 00:13:31 CET