Re: Question on Primary Keys

<rs> wrote in message news:sunp5nebkfmn2f_at_news.supernews.com...
>
> I know that (OrderNum, LineNum) should semantically be the PK.
>
> What if the following were done :
>
> set OrderLineID as the PK for the ORDERLINE table, and have OrderNum
 as
> a FK.
>
> By doing that, am I helping myself in terms of efficiency with indexing in
> any way or
> is there no real benefit from doing that?
>
> If I wanted to go forward with the approach I described, how would I set
 up
> a unique
> sequence in Oracle in order to accomplish this ?
>
> Raju
>
If you index on OrderNum in the ORDERLINE table, yes, I believe there is a benefit.

-ERMREY Received on Wed Oct 25 2000 - 19:47:29 CEST