RE: [firebird-support] index use when using order by

['Andrew Zenz' and...@aimsoftware.com.au [firebird-support]]

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