When to Fire Triggers - Analytics Database - Teradata Vantage

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

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.