On Wed, 24 Jul 2013 04:22:33 -0000, "ttt_dev" <[email protected]> wrote: > hi, thanks for any help with this... > > i need to select the first x records from a view ordered by ID descending. > > when the view does not contain an ORDER BY statement then the query is > rapid. however when i put an ORDER BY statement in then the query becomes > extremely slow (from 1 sec to nearly 1 min). > > i tried to add a descending index on the docs_search_terms table then > recomputed the indexes afterwards with little effect. > > i will paste the SQL and the plan below. i would be grateful for any > assistance with this. thanks.
Which version of Firebird? Mark
