--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

> > CREATE INDEX IDX_1 ON T (Foo DESC)
> No it didn't ;)

Yes, it`s my typos, sorry. :)

> You are using a query without a where clause. The optimiser thinks it
> is quicker to read the data into memory

Ok, but what is the 'where' (or PLAN?) clause that will "force" using
individual ('desc foo', and 'asc bar') indexes?


Zoltan.