How can I build a compound index in Firebird database with one field ascending and another one descending? Like account number ascending and date in descending order.
2 Answers
The Firebird syntax of CREATE INDEX only allows you to specify a direction for the index as a whole. It is not possible to order individual columns in the index.
Related