You can specify when triggers fire.
Option | When Triggered Action Runs |
---|---|
BEFORE | Before triggering event completes. As specified in the ANSI/ISO SQL standard, a BEFORE trigger cannot have data changing statements in the triggered action. |
AFTER | After triggering event completes. To support stored procedures, the body of an AFTER trigger can include a CALL statement. Both row and statement triggers can call a stored procedure.
|
Sometimes a request fires a trigger that fires another trigger. Analytics Database processes and optimizes the triggered and triggering statements in parallel to maximize system performance.