Triggers Part 2: Facts and Frequently-Occuring-Problems (FOP)
This is part of a 3 part epic mini-series on triggers, view Part 1 and Part 3. When are triggers fired, and how many times? For your standard missionary position trigger, they are fired once per batch. So if you have an update statement that affects 57 rows, then the DML AFTER trigger fires *once* … [Read more…]