Subject Re: [firebird-support] How to gat a good performance
Author Pavel Menshchikov

d> My problem is when executing the query below, firebird takes much
d> longer time to get a result than MSSQL.

d> SELECT MAX(field_A) as max_A, field_B FROM TABLEX GROUP BY field_B


d> What should I do to get a better performance with firebird ?

Try to add DESC index on field_A: in FB indices are uni-directional.
If field_A has a poor selectivity, add compound DESC index on
(field_A, primary_key) instead of adding DESC index on field_A.

Best regards,
Pavel Menshchikov