Refrential integrity

[farrokhp]

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

Thanks

[tamilselvan]

Yes. You must have.

If the INDEX is not available, you will have performance problem.