Re: [firebird-support] Re: MAX() wants a DESC index ?
Author
Jerome Bouvattier
Post date
2003-11-18T12:32:44Z
----- Original Message -----
From: Alexander V.Nevsky
To: firebird-support@yahoogroups.com
Sent: Tuesday, November 18, 2003 12:51 PM
Subject: [firebird-support] Re: MAX() wants a DESC index ?
> > 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.