Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why do after row triggers exists?

Re: Why do after row triggers exists?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 18 Jan 2003 15:41:23 -0000
Message-ID: <b0bsj2$6b1$1$8302bc10@news.demon.co.uk>

Further to the other replies, you might be interested to know that Steve Adams has
a note on his website pointing out that
after row triggers on updates generate less work than before row triggers - so if you have the choice, the after row trigger is the better choice.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23
____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Jaap W. van Dijk wrote in message
<8i5i2vk16ji6vvkggfbm4mbtrkv74hjop9_at_4ax.com>...

>Hi,
>
>A general question:
>
>What can be accomplished with an after row trigger that can not be
>done with a before row trigger?
>
>Jaap.
Received on Sat Jan 18 2003 - 09:41:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US