Are triggers evil?
731589Nov 8 2009 — edited Nov 9 2009Hi,
A friend who works directly with Oracle told me everything must be done in order to try to avoid using triggers, but I couldn't understand why.
I'm not an Oracle (or any other database) expert, but I can understand that a trigger is a block of code that is executed for every insert, update or delete (I know you can say when to run it when you create it), so you have to be cautious not to run things too complicated or to "heavy" in order to not make the whole database slow. But, again, I think you need to be cautious with what your triggers are doing, but you don't need to avoid using them.
Is there anything I am missing?
Thanks in advance,
João Toledo