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

From: amonte <>
Date: Fri, 25 Jan 2013 00:15:39 +0100
Message-ID: <>

Hi Rich
your query returns all rows in dept

why am I thinking oracle should be smart enough to detect this? it is because CBO can now do join elimination and the example I posted it is not difficult to implement in CBO no?


Received on Fri Jan 25 2013 - 00:15:39 CET

Original text of this message