Hiyour 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 in min queries and order by xx asc.Regards,Karol Bieniaszewski null
RE: [firebird-support] index use when using order by
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Tue, 17 Sep 2019 21:48:06 -0700
- [firebird... 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
- RE: ... 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
- ... 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
- Re: ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
- RE: ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- ... 'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]
- ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]