danyschaer wrote:

>
> Here you have my test, with an index like the one I am testing in
> Postgres, but in descending order as you sugested; Firebird still
> does not use it.
>
> Please let me know if you have any other idea, and thank you !!

CREATE DESCENDING INDEX MOVI_FECH_DESC ON MOVI (FECH);

I'd be interested in the timings and the plan with the above index.


Dmitry