In early versions as I remember you needed an index on both sides of the
join for it to work so if you had a table that had for example a zipcode
that was a foreign key in to the second table that was a lookup for the
state not only did the second table need an index on its key the primary
table had to have an index on the zipcode foreign key.