Subject Re: [firebird-support] slow order by performance on a view
Author Mark Rotteveel
On Wed, 24 Jul 2013 04:22:33 -0000, "ttt_dev" <ttt_dev@...>
> hi, thanks for any help with this...
> i need to select the first x records from a view ordered by ID
> 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
> 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?