Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 only difference is that by employing a trigger a small overhead is added - the equivalent of making a PL/SQL call. (btw, is somebody else using google groups here? is anybody else loosing his/her posts as well?) Received on Mon Apr 23 2007 - 13:19:05 CDT
![]() |
![]() |