martinknappe wrote:

>
> now, my fields are too big for a joint index on asterm ascending, id
> ascending to be created so i had to rewrite the procedure in a more
> complicated way.

It probably doesn't resolve your problem, but Firebird will use
two separate indexes on the same query. They don't show up in
the plan because the plan just shows the major structure of the
retrieval algorithm. So your "more complicated" query may not
be necessary.


Regards,


Ann