Subject Re: [ib-support] unique constraints
Author Martijn Tonies
> If I create a unique constraint on a pair of columns on a table, should I
then also create a index on the same columns to make it fast to check the
constraint or is this done implicitly?

To "check the constraint"? What does that mean?

Anyway, IB/Fb automatically creates indices for PKs, Unique constraints
and FK-constraints.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."