Subject do fields with foreign key need index
Author
if table A has a primary key

and table B has a field with a foreign key on A.primary
does that field in table B also need an index or will it use the index for the primary key?