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.