|Subject||RE: [ib-support] Unique fields|
> Is it possible to make a field unique without specifying anTechnically, yes.
> index on it?
You could create a trigger which would need to perform a select to
ensure/enforce uniqueness, but if the table is large... that could end
up being a very expensive/time consuming process.
A unique index is really the way to go.