Re: snapshot vs trigger
From: <gsalem_at_fr.oracle.com>
Date: 1995/10/10
Message-ID: <45dke3$6j9_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1995/10/10
Message-ID: <45dke3$6j9_at_inet-nntp-gw-1.us.oracle.com>#1/1
jes_at_usa.pipeline.com(Johnnie Suggs) wrote:
>as a new comer to the dba admin world...i have a question...
>
>i have a user who wants to update a seconday table when
>a row is updated in a particular table. he knows he can
>write a trigger..but...i was wondering if a snapshot wouldn't
>be better?
>
>--
>
>Johnnie Suggs
if it is in the same database, triggers would offer synchronous updates,
while snapshots are asynchronous, and use more space (for snapshot logs).
On a distributed system (different machines), snapshots allow for better
performance and network independent operations (triggers would fail if the network
fails).
Received on Tue Oct 10 1995 - 00:00:00 CET