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,

Trouble with OR

2004-02-03 Thread Yun Li
Good day everyone, I've been having trouble using OR in my queries. I hope someone could help me. I have three tables t0 (k0, k1, k2), t1 (k0, k1), and t2 (k0, k2), linked through three columns k0, k1, k2. Specifically the linkages are: t0.k0 = t1.k0 and t0.k0 = t2.k0 and ( (t0.k1 =