In general it is a good idea to limit the number of records and
fields returned as much as possible. If you are only interested in
the first record, just use FIRST. Other options (depending on what
you want to do) are using MAX/MIN or EXISTS.

Set

--- In ib-support@yahoogroups.com, "zaher" <zaher@s...> wrote:
> Firebird for sorting without index build a data internaly
> ,sort the records and send them to client
> but when use FIRST there is no need to build that data , just find
th first record
> accepted the sort
>
> any one agree with me.
>
> sorry for poor english.