Having a foreign key should probably be a hint to the planner that it should create a cross-table correlation estimate on the source and destination columns. Th

Having a foreign key should probably be a hint to the planner that it should create a cross-table correlation estimate on the source and destination columns. This is about join cardinality estimation, not having an index.