Subject Re: Primary key question
--- In ib-support@y..., "Nico Callewaert" <ncw@c...> wrote:
> Hi all,
> I'm planning to make a table and the primary key of that table
would be a
> combination of 4 fields. Would such a primary key slow down my
queries ?
> Is a one field primary key better ??

Hi, Nico.
Yes. And more: if you need references on the table with composite
primary, you need to include all it's segments into tables that
references on it even if nature of the table does not reqiure this.
For uniquity of columns that define "natural" primary, you always can
create general unique index on this columns and use it where it is

Best regards.