Referential Integrity Degrading Database Performance
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:
Do you have any similar experience with referential integrity constraints?
DevX Senior Editor
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL