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 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.