I was wondering,
What will be my motivation to use constraint as foreign key in MySQL, as I am sure that I can rule the types that are added?
Does it improve performance?
2 Answers
One reason is that a set of tables with foreign key constraints cannot be sharded into multiple databases.
Related