operator OR slows down query?

2004-02-20 Thread Yun Li
hello, everyone I am having problem using the operator OR. when I test for condition A OR B in a query, the query becomes extensively slow or even fails, even though a test on condition A or B alone gives result right away. If you happened to know what the problem it or have any suggestion,

Re: operator OR slows down query?

2004-02-20 Thread Keith C. Ivey
On 20 Feb 2004 at 10:57, Yun Li wrote: I am having problem using the operator OR. when I test for condition A OR B in a query, the query becomes extensively slow or even fails, even though a test on condition A or B alone gives result right away. See

Re: operator OR slows down query?

2004-02-20 Thread Bill Marrs
I am having problem using the operator OR. when I test for condition A OR B in a query, the query becomes extensively slow or even fails, even though a test on condition A or B alone gives result right away. I learned recently that you can often use a UNION to solve problems like this. It's