You should almost always index foreign keys. The only exception is when the matching unique or primary key is never updated or deleted. For more information take a look on Concurrency Control, Indexes, and Foreign Keys.
The sql file which will generate these indexes is created for you