> A less obvious referential integrity performance requirement is ensuring your FKs are indexed. For the sake of precision, this is a requirement in MySQL¹:

> 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-keys.html https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign...