Pitfalls of Soft Deletes: Measuring the Impact on Unique Constraints, Indexes, and FKs in MySQL｜Kou

IntroductionIt is a common story that a table started with the assumption that "soft deletes using `deleted_at` are safe" ...