Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
>> If not, does an Order-by force a sort even if an index has the correct
>> order to satisfy the order-by?
> If a btree index is chosen that satisfies the order by, the sort is
> avoided.
And, of course, selection of that index is encouraged,
> Frequently one wants a data set returned in the same order as the
> index used in the query. Informix (at least) has implicit order-by,
> which means that the data will be returned in collating order if the
> query forces use of the appropriate index.
>
> Does Postgresql do this?
Yes, but sam
