SQL & PL/SQL

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!

Disabling Vs Dropping constraints

574641Apr 8 2010 — edited Apr 8 2010

Folks,

Never found a good documentation which explains the below queries I have. Could you answer them?

1. Why is it good to not having a foreign key constraint between two tables, when a delete operation is happening? my DBA told me to drop the foreign key constraints, then delete from child and parent tables and then create the Fkey constraints again. I think this is to enhance performance? How does this enhance performance?

2. What is the difference between Disbale/Enable VS Drop/Recreate constraints when it comes to performance? Which is better?

Thanks,
Saff

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2010

Added on Apr 8 2010

4 comments

3,849 views