Friday, March 30, 2012

Pros & Cons of Using Triggers

Hello,
Can anyone tell me what are the pros and cons of creating and using triggers
in the database? Are there any performance and debuggins concerns?
TIA,
Dee
Triggers are primarily intended for providing procedural integrity, however
they can be used for several purposes. There are no generalized "pros &
cons" per se with triggers, but in specific situations you might come across
performance problems with locking, serialization and concurrency issues.
Anith
sql

No comments:

Post a Comment