I already had one. So I changed the RDB$PRIMARY62 to the index
name. This did not change it at all. But thanks for the suggestion.

Trac

--- In firebird-support@yahoogroups.com, "Aurimenes Apolonio"
<aurimenes@c...> wrote:

> 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@y...>
> >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.