A bulk load that got slow

• A

  The audit table needing an index rebuild at the end of the load

• B

  Two million trigger invocations, each inserting a row and generating its own log records

• C

  Lock contention on the audit table, as every inserted row waits its turn

• D

  The trigger statement having to be parsed and recompiled once for each and every inserted row