if trigger is written on after update and if i am updating 100 row how many time trigger will fier. will it affect performance of database? if so what is the solution
Trigger
if trigger is written on after update and if i am updating 100 row how many time trigger will fier. will it affect performance of database? if so what is the solution
Normal trigger fires only once on the event. For each row trigger fires once for each row.
For each row option determines whether a trigger is row trigger or statement trigger.Originally Posted by goodstudent
if trigger is written on after update and if i am updating 100 row how many time trigger will fier. will it affect performance of database? if so what is the solution
If you include for each row option in your trigger definition it fires 100 times otherwise it fires only once.
Last edited by krishnaindia2007; 03-14-2008 at 06:05 AM.
Posting Permissions
Reply With Quote