Can somebody tell me that is it mandatory to have index on foreign key consatraint field?
Thanks
Printable View
Can somebody tell me that is it mandatory to have index on foreign key consatraint field?
Thanks
Yes. You must have.
If the INDEX is not available, you will have performance problem.