Subject RE: [firebird-support] Sloooow query
Author Dmitry Yemanov

> Thanx for all your help!
> I'm gonna do some thourough tests before I report the results back.

From what I see, the only problem you won't be able to solve is the external
sorting (SORT plan). That's because of your ORDER BY clause which contain
two different sorting criteria. Upgrading to FB 1.5 could probably solve
this issue too.

I would like to know how much time this query takes if executed without the
ORDER BY clause. It would allow to suggest you some further steps for
optimization, if possible.