redtneen wrote:

[Adding an order by to a stored procedure for select do loop
increased execution time from 3s to 6s]

>
> although this field is Indexed and the optimizer uses this index
> (no sort was performed)
>
> i need to know where this time goes in if possible how to sppeed up
> this statement

The time went into retrieving the data in index order rather than
in storage order. Dropping the index or altering the query so the
index can not be used may improve the query performance by allowing
Firebird to access the data in storage order.

Regards,


Ann