News for hackers. Stuff that matters.
Re:Feature Casualties of Large Databases by pizza234 on Tuesday December 01, 2020 @07:04PM (#25271738)
> A less obvious referential integrity performance requirement is ensuring your FKs are indexed.

For the sake of precision, this is a requirement in MySQL¹:

> MySQL requires indexes on foreign keys and referenced keys so that foreign key checks can be fast and not require a table scan

¹=https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign...

There are no comments on this comment yet.