Re: outer join between parent-child, not null and FK constraints
From: amonte <ax.mount_at_gmail.com>
Date: Fri, 25 Jan 2013 20:59:55 +0100
Message-ID: <CABV7K9tirCM6y8=TB44jS53YSpHhJx0965Vw04cjQMEyB9ErUA_at_mail.gmail.com>
Hi Stephane
I am asking this simply because I was thinking if Oracle is capable to eliminate join from 11gR1 why it cannot eliminate redundant outer joins. That's all. I am not meaning we should not use outer join nor write proper queries. I simply wanted to prove that my thinking about outerjoin+fk+not null, if all 3 conditions are met outer join is not needed
Date: Fri, 25 Jan 2013 20:59:55 +0100
Message-ID: <CABV7K9tirCM6y8=TB44jS53YSpHhJx0965Vw04cjQMEyB9ErUA_at_mail.gmail.com>
Hi Stephane
I am asking this simply because I was thinking if Oracle is capable to eliminate join from 11gR1 why it cannot eliminate redundant outer joins. That's all. I am not meaning we should not use outer join nor write proper queries. I simply wanted to prove that my thinking about outerjoin+fk+not null, if all 3 conditions are met outer join is not needed
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 20:59:55 CET