Can somebody tell me that is it mandatory to have index on foreign key consatraint field?

Thanks