[rt-users] Re: Slow Queries

[Tony Bowden]

On Tue, Oct 24, 2006 at 01:54:53PM -0400, Asif Iqbal wrote:
> Here is another query that takes 6.95 secs
 ... 
>  AND ( (main.Status = > 'S')OR(main.Status = 'S') )
...
> Is there a way to improve this?

<guess>
Introducing an 'OR' into any SQL generally slows it down. In this case
the OR appears to be unnecessary, so if there were a way to remove it 
this might make a difference.
</guess>

Tony