Dmitry,

> Do you try ORDER statement?
> select first 1 *
> from employee
> order by hire_date desc

That's great:
PLAN (EMPLOYEE ORDER IDX_EMPLOYEE_HIRE)

but *only* when the Index IDX_EMPLOYEE_HIRE is also declared as
DESCENDING.

Thanks :-)


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird