Hacker News new | ask | show | jobs
by scottcodie 1387 days ago
Foreign keys also let the query optimizer make better query plans. This is actually a bigger deal than most people think, the query optimizer can rewrite to semi joins or even eliminate joins completely if the optimizer has better guarantees about referential integrity.
1 comments

Could you give us a simple example?