SQL - Triggers
Consider a trigger that updates a log table after each row insert on a large table. What is the likely performance impact?
Consider a trigger that updates a log table after each row insert on a large table. What is the likely performance impact?
medium📝 query result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand trigger behavior on inserts
Triggers run synchronously during insert operations.Step 2: Analyze effect of logging in trigger
Logging each row insert adds extra work, slowing down the insert.Final Answer:
The insert operation will slow down due to extra logging -> Option AQuick Check:
Logging in trigger = Slower inserts [OK]
Quick Trick: Triggers run synchronously, adding to operation time [OK]
Common Mistakes:
- Assuming triggers run asynchronously
- Thinking triggers speed up operations
- Believing triggers block all inserts
Master "Triggers" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes