Answer
Triggers automate actions but add overhead to write operations, making heavy trigger use slow and harder to debug.
Quick Answer
Triggers add overhead: they execute hidden SQL for every matching DML operation, increasing write latency. Cascading triggers (trigger fires another trigger) multiply the overhead. Triggers are not visible in EXPLAIN, making performance debugging harder. Alternatives: application-layer logic or scheduled jobs for audit/denormalization. Only use triggers for database-level enforcement that can't be enforced at the application layer.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ