Alexander Tabakov schrieb:

> 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.

You should not get duplicate indices here: The PK-Index is created on
table "TBL_PERSON", the FK-Index is created on table "TBL_PERSON".

Elmar