| Subject | RE: [firebird-support] index use when using order by |
|---|---|
| Author | Andrew Zenz |
| Post date | 2019-09-18T04:50:46Z |
Thanks.
Excuse me while I find a brick wall to bash my head against.
Andrew Zenz
From:
firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, 18 September 2019
2:47 PM
To:
firebird-support@yahoogroups.com
Subject: RE: [firebird-support]
index use when using order by
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 in min queries and order by xx asc.
Regards,
Karol Bieniaszewski