"markd_mms" <spam@...> wrote:

>
> but as soon as I add
>
> ORDER BY ITEM.TITLE ASC
>
> the query takes over 4 minutes to run. There is an ascending index on
> ITEM.TITLE that I tried removing but it doesn't make a difference.
>
> Does anyone know why it could be making such a big difference?

Because the entire record set is sorted externally. An index-based ordering
is not supported for outer joins in versions prior to FB 2.0.


Dmitry