You probably know about the mechanism for enforcing business rules in Oracle
databases called referential integrity, which is implemented via foreign key
(FK) constraints that are supported by corresponding indexes. What you may
not know is that severe performance problems can result when FK constraints
aren't indexed. If you're interested in learning how to avoid performance
issues during SQL queries and massive DML operations when those important
indexes are missing, check out this article recently posted on DevX:

http://gethelp.devx.com/techtips/ora.../10min0102.asp

Do you have any similar experience with referential integrity constraints?

Regards,

Stefan Gruenwedel
DevX Senior Editor