Foreign Keys, Blocking, and Update Conflicts
SQL Performance
JUNE 17, 2021
Most databases should make use of foreign keys to enforce referential integrity (RI) wherever possible. However, there is more to this decision than simply deciding to use FK constraints and creating them. There are a number of considerations to address to ensure your database works as smoothly as possible. This article covers one such consideration that does not receive much publicity: To minimize blocking , you should think carefully about the indexes used to enforce uniqueness on the parent s
Let's personalize your content