On 15 Jan 2011, at 23:52, Randall Smith wrote:
> Hi,
>
> I've created a trigger that checks the uniqueness of two columns in a
> table. Traditionally, one would use a unique constraint, but in my
> case, the size of the unique index would be too large and some
> performance loss is acceptable.
But you already do have an index on that id-field, so what's the problem with using a unique constraint? Its unique index could just replace the existing one.
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:737,4d323b1e11871071717716!