Hi All,

A trivial example (FB 1.5.4):

CREATE TABLE T (Foo VARCHAR(20), Bar INTEGER);

SELECT * FROM T
ORDER BY Foo DESC, Bar

How can I create an index for this query? (yes, I want that Foos are
descending order and Bars are ascending order)

CREATE INDEX IDX_1 ON T (Foo DESC, Bar)

Statement failed. :(
But,

CREATE INDEX IDX_1 ON T (Foo DESC)
CREATE INDEX IDX_2 ON T (Bar)

Statements are OK, but the query is don`t use these indexes. :(


Zoltan