Databases · Senior · Question 62 of 75
What is the main risk of ON DELETE CASCADE chains in a large schema?
- 1Cascades make inserts fail
- ✓Correct answer: One delete can silently remove large amounts of related data and hold many locks for a long time
- 3Cascades don't work with indexes
Explanation
Use cascades where child rows truly have no meaning alone. For large or important data, prefer soft deletes or explicit, batched cleanup.