Triggers and Performance

Trigger performance overhead is usually low. The time involved in running a trigger is spent mostly in referencing other tables, which can be either in memory or on the database device. The deleted and inserted tables are always in memory. The location of other tables referenced by the trigger determines the amount of time the operation takes.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.