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

From: amonte <ax.mount@xxxxxxxxx>
To: saibabu_d@xxxxxxxxx
Date: Fri, 25 Jan 2013 07:57:50 +0100

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


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

References:
- Re: outer join between parent-child, not null and FK constraints
  - From: Saibabu Devabhaktuni

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