In triggers and procedures conditions are not analize and all instructions bellow that condition are prepared,.
Ex. I have a trigger and I put there the following condition in a trigger after update in a table2:
if ( 1=2) then
update table1 set field1=field1+1;
table1 have 1.000.000 of records and when I change a record in table2 takes a long time and exception is never show but if I put the triggers like
if (1=2) then
/*update table1 set field1=field1+1; */
it is fast.
Please help me all me databases are very slow because this and I swear you that this is true.
Analyze and fix this , Please .....................