Subject Re: [firebird-support] SQL Query question
Author Aurimenes Apolonio

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.


>De:"tractaylor" <tractaylor@...>
>Assunto:[firebird-support] SQL Query question
>Hey Everyone!
>Let me start by saying I am using Firebird 1.5
>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

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