If you designate it as a foreign key in the schema it'll just use the PK index e...

philwelch on Dec 28, 2013 | parent | context | favorite | on: PostgreSQL indexing in Rails

If you designate it as a foreign key in the schema it'll just use the PK index even if you don't join that table in at all? Wait, how does that even work? Does the PK index include the foreign key rows then? That's an awesome feature.