Hello,

I am new to Firebird SQL and I'm trying to develop a small application
with it.

Using IBExpert and looking at the Plan Analyzer I've noticed that
using a select that looks like this: SELECT * FROM <table> ORDER BY
<field> ASC; will not use the existing descending index on <field>. I
found this weird because in other DB systems that I've used if I
create an index on <field> it will be used for both ASC and DESC
orders. Maybe I'm doing something wrong, can anyone help me ?