Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger performance overhead

281875Jul 29 2003 — edited Jul 30 2003

Does anyone know there is a performance overhead if using trigger to check the data integerity?
The case is we want to check whether the master record has been used in child tables, if yes, don't not allow to update the master record as "disabled".
Is it better to check this in before-update trigger or check in application??

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2003

Added on Jul 29 2003

#general-database-discussions

4 comments

372 views