> AI Rumman wrote: >> Does FK Constraint help to improve performance? Or it is only >> for maintaining data integrity?
> I'm not aware of any situation where adding a foreign key > constraint would improve performance.
There's been talk of teaching the planner to use the existence of FK constraints to improve plans, but I don't believe any such thing is in the code today.