Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Table Join Question

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@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 - 01:22:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US