--- In firebird-support@yahoogroups.com, "Jerome Bouvattier"
<JBouvattier@I...> wrote:

> Hello all,
> With FB (1.5 RC6), I noticed the MAX(<a_field>) needs a DESC index

on

> <a_field> to actually make use of an index.
> Can someone enlight on why such a behaviour, if normal ?

It is normal and conditioned by fact FB use b-tree indices which are
unidirectional - have links to next pages, not previous.

Best regards,
Alexander.