I am designing a MySQL database using the "MySQL Workbench". I have created a design which includes lots of RI, but what are the performance implications of RI?
Please could you refer to the following illustration of the WordPress database:
Attribute: "parent" may optionally refer to another "wp_term_taxonomy"
- What reasons might the WordPress designers have chosen to not enforce RI for term hierarchies?
- Are there any performance benefits with RI and foreign keys?