- Foreign keys help enforce referential integrity at the data level. They also improve performance because they’re normally indexed by default.
- Foreign keys can also help the programmer write less code using things like
ON DELETE CASCADE
. (cascade deletion across all related entries in other tables)