Skip to Main Content

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!

Does triggers effect the performance

user11278505Dec 7 2009 — edited Dec 7 2009
Hi all,

I have 3 triggers on the table....2 of which are select triggers and one is it insert into other tables whenver there insert/update/delete for each row..

so if i do dataload say 1 lac rows on the table which has trigger.
does trigger slows down the performance.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2010
Added on Dec 7 2009
4 comments
6,628 views