Hi,

I don't know if it's going to work, but try adding indexes on the fields you use in the relations, like primary keys etc.

Aurimenes

=================

>De:"tractaylor" <tractaylor@...>
>Para:firebird-support@yahoogroups.com
>Assunto:[firebird-support] SQL Query question
>
>
>
>
>
>Hey Everyone!
>
>Let me start by saying I am using Firebird 1.5
>RC8.
>
>I have a question about one of my sql statements
>in my applications.�
>The sql will be below.� Basically, I have this
>query that runs fast
>normally.� But as soon as I put a order by
>clause, it takes lots of
>time.� I do have a index of the order by column
>I am using.� Let me
>show you the sql and the plans that are being
>used.� I also have the
>stats that I will show below.
>
>//----------------------------------

___________________________________________________________________________________
Acesse nosso portal www.click21.com.br

Porque internet gr�tis, nem a Embratel pode fazer mais barato. Mas pode fazer melhor.