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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
