Coming across that early in my freelancing career, I create indexes on foreign keys by default now via auto-configuring it with ORM.

It's almost always needed, and it's easier to remove them if they somehow become a problem.