Saturday 26 May 2012

How can the performance of a trigger be improved? | PL SQL

 The performance of a trigger can be improved by using column names along with the UPDATE clause in the trigger. This will make the trigger fire when that particular column is updated and therefore, prevents unnecessary action of trigger when other columns are being updated.