> 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
http://www.upscene.com

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