Re: outer join between parent-child, not null and FK constraints

From: amonte <ax.mount@xxxxxxxxx>
To: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
Date: Fri, 25 Jan 2013 20:59:55 +0100

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


--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell
- RE: outer join between parent-child, not null and FK constraints
  - From: Iggy Fernandez
- RE: outer join between parent-child, not null and FK constraints
  - From: Iggy Fernandez

References:
- outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell
- Re: outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: David Fitzjarrell
- Re: outer join between parent-child, not null and FK constraints
  - From: amonte
- Re: outer join between parent-child, not null and FK constraints
  - From: Stephane Faroult

Other related posts:

» outer join between parent-child, not null and FK constraints- amonte
» RE: outer join between parent-child, not null and FK constraints- Ric Van Dyke
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» RE: outer join between parent-child, not null and FK constraints- Ric Van Dyke
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- Saibabu Devabhaktuni
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- amonte
» Re: outer join between parent-child, not null and FK constraints- Saibabu Devabhaktuni
» Re: outer join between parent-child, not null and FK constraints- Stephane Faroult
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints - amonte
» Re: outer join between parent-child, not null and FK constraints- David Fitzjarrell
» Re: outer join between parent-child, not null and FK constraints- Taral Desai
» Re: outer join between parent-child, not null and FK constraints- amonte
» RE: outer join between parent-child, not null and FK constraints- Iggy Fernandez
» RE: outer join between parent-child, not null and FK constraints- Iggy Fernandez