Helen,

> Because of the ambiguity of two identical indexes, it uses *no* index.
> So it will join, sort, etc. by organising the column in natural order.

Never been able to reproduce it. My tests show that one of the indexes
is always used (IB4.2 tends to use them both). Out of curiosity, have
you got a suitable example?
Ciao
--
____
_/\/ando