Re: all foreign key should have index?



>> Is it necessary that all foreign key should have index? <<

No. But better SQL products construct a "PK=FK" index under the
covers for you.

.