Contents Index Replace expensive triggers Pay attention to the order of columns

ASA SQL User's Guide
  Monitoring and Improving Performance
    Top performance tips

Minimize cascading referential actions


Cascading referential actions are costly in terms of performance, because they cause updates to multiple tables for every transaction. For example, if the foreign key from employee to department were defined with ON UPDATE CASCADE, then updating the department ID would automatically update the employee table. While cascading referential actions are convenient, sometimes it might be more efficient to implement them in application logic.


Contents Index Replace expensive triggers Pay attention to the order of columns