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

From: amonte <>
Date: Fri, 25 Jan 2013 07:57:50 +0100
Message-ID: <>

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?


Received on Fri Jan 25 2013 - 07:57:50 CET

Original text of this message