I have defined an UNIQUE field in one table, this field is used in
joins to several other tables (used as foreign key).

But I notice that the index created for this unique property is not
used in the plans for my joins !?

If I create a specific index for this field, that index is used.


Anyone have any idea why this is happening?


---
frode