> I have the following case:
>
> 1. TBL_PARTY, primary key PARTY_ID
> 2. TBL_PERSON references TBL_PARTY on PARTY_ID
>
> So, PARTY_ID is a FK in TL_PERSON which means I have an index created,
> but PARTY_ID is a PK also. I don't like tables without PK defined, but
> in that case I will get 2 indexes on one and the same field which is
> not good also.
>
> What is your opinion about that? Can I avoid one of the indexes?
>
> --
> Best regards,
> Alexander mailto:saho@...

If TBL_PERSON and TBL_PARTY share the same PK - why don't you just have the
fields in TBL_PARTY to the TBL_PERSON table.

Alan