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,
DeeTriggers 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

No comments:

Post a Comment