Re: Table Join Question
From: Heinz Huber <Heinz.Huber_at_elbanet.co.at>
Date: Tue, 22 Aug 2000 08:22:45 +0200
Message-ID: <39A21C35.AC1553EA_at_elbanet.co.at>
Date: Tue, 22 Aug 2000 08:22:45 +0200
Message-ID: <39A21C35.AC1553EA_at_elbanet.co.at>
Joining with a primary key should always give you a better performance since the index is unique.
Regards,
Heinz
sriniv79_at_my-deja.com wrote:
>
> Thanks Joe, but no thanks :))
>
> As you have said, my example was faulty. Sorry about that. I will also
> post the DDL next time!!
>
> But I have inherited a huge 60+ table legacy schema, where I could do
> the joins either way. If it were the case, does your post imply I
> should always join back to the table which has the primary key?
>
> -S
Received on Tue Aug 22 2000 - 08:22:45 CEST