Re: "OR" in the JOIN clause -- very very slow!

2002-07-29 Thread Benjamin Pflugmann
Hi. On Sun 2002-07-28 at 17:58:36 -0700, [EMAIL PROTECTED] wrote: > hello, > > i have a couple of questions about my SQL query. > > 1. if i want all rows in table 1 that may or may not have a counterpart > row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it > a simple joi

Re: re: "OR" in the JOIN clause -- very very slow!

2002-07-29 Thread Egor Egorov
Erick, Monday, July 29, 2002, 3:58:36 AM, you wrote: EP> i have a couple of questions about my SQL query. EP> 1. if i want all rows in table 1 that may or may not have a counterpart EP> row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it EP> a simple join (i.e., without th