Re: using sequences in triggers to generate identities

On Apr 23, 12:47 pm, if <filip1..._at_gmail.com> wrote:
> Hi,
>
> ';m coming from a db2 background.
> I was wondering if in Oracle there is any performance (or other)
> difference between using a sequence in insert statements and using an
> insert trigger to do the same job.

The difference is that by implementing it in a trigger you add a bit of overhead (the one required to make a PL/SQL call for trigger execution).

Valentin Received on Mon Apr 23 2007 - 13:12:55 CDT