> Yes, if you are concerned about the performance of updates/deletes on
> the departments table. The reason the system doesn't make such an index
> automatically is that there are common scenarios where you seldom or
> never update the master table, and so the index wouldn't repay the cost
> it creates for updates of the slave table.
Thanks for the explanations :-)
regards
--
Arnau