Thanks everyone, I have added a descending index to the tables required,
it makes a big difference.
Andrew Zenz
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, 18 September 2019 4:04 PM
To:
On 2019-09-18 06:46, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi
>
> your problem is that you have ascending index, which is not usable in
> descending queries. You need to create descending index and it then
> can be used in e.g. max queries. Ascending index is used