On Tue, Feb 25, 2003 at 07:56:14AM -0800, Stephan Szabo wrote:
>
> On Tue, 25 Feb 2003, Anuradha Ratnaweera wrote:
>
> > Question in brief: does the planner/optimizer take into account the
> > foreign key constraints?
> >
> > If the answer is "no", please stop reading here.
>
> Not really. However, as a note, from t1,t2 where t1.id=t2.id is not
> necessarily an identity even with the foreign key due to NULLs.
"not null" doesn't make a difference, either :-(
Anuradha
--
Debian GNU/Linux (kernel 2.4.21-pre4)
It's not Camelot, but it's not Cleveland, either.
-- Kevin White, Mayor of Boston