Trigger Efficiency in Oracle

(Alexander Ocher) The documentation for Oracle 9.2 and previous versions contains the following paragraph: “AFTER row triggers are slightly more efficient than BEFORE row triggers. With BEFORE row triggers, affected data blocks must be read (logical read, not physical read) once for the trigger

Read More - Register for Free Membership