Re: outer join between parent-child, not null and FK constraints
From: amonte <ax.mount_at_gmail.com>
Date: Fri, 25 Jan 2013 07:57:50 +0100
Message-ID: <CABV7K9uekf1dZY7GDX9tqUFqzahxwq+DFe42pVMKdj_KOeZ-qw_at_mail.gmail.com>
Hi Saibabu
I know you cannot apply not null in outer join because outer join returns NULLs so with a not null constraint in hand why CBO cant eliminate the outer join? Isnt it simple to do so?
Date: Fri, 25 Jan 2013 07:57:50 +0100
Message-ID: <CABV7K9uekf1dZY7GDX9tqUFqzahxwq+DFe42pVMKdj_KOeZ-qw_at_mail.gmail.com>
Hi Saibabu
I know you cannot apply not null in outer join because outer join returns NULLs so with a not null constraint in hand why CBO cant eliminate the outer join? Isnt it simple to do so?
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 07:57:50 CET