Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why do after row triggers exists?
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>...Received on Sat Jan 18 2003 - 09:41:23 CST
>Hi,
>
>A general question:
>
>What can be accomplished with an after row trigger that can not be
>done with a before row trigger?
>
>Jaap.