Subject Re: [ib-support] do I need to compare in this trigger...
Author Peter Faulks
On Wed, 10 Apr 2002 17:59:31 -0000 "csswa" <csswa@...> wrote:

> 1. if new.pk <> old.pk then new.pk = old.pk
> 2. new.pk = old.pk
>
> Is doing the comparison slower than simply doing version 2 every time?

My money's on version 2 is definately faster (especially if the PK was a
char(n))

Regards