Dmitry,

> > if the DISTINCT's argument has an index, it is used and you get an
> > ordered result set.
> > I still won't be sorting, but the rows will be in order.
> > At least that's what I recall.
>
> Sorry, this is not true. With DISTINCT, indices are not used, but the result
> buffer is sorted.

you are right (and it sounds logical too).

> I can't recall at the moment whether IB4/5 behaves in the same
> manner or differently.

Same thing, just tested.
Ciao
--
____
_/\/ando