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:confused:
Printable View
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:confused:
Normal trigger fires only once on the event. For each row trigger fires once for each row.
[QUOTE=goodstudent;27538]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:confused:[/QUOTE]
For each row option determines whether a trigger is row trigger or statement trigger.
If you include for each row option in your trigger definition it fires 100 times otherwise it fires only once.