Re: BIG Joins
From: John Anest <janest_at_panix.com>
Date: 15 Jul 1994 07:42:59 -0400
Message-ID: <305so3$50k_at_panix.com>
Date: 15 Jul 1994 07:42:59 -0400
Message-ID: <305so3$50k_at_panix.com>
In article <9407131738.PN05420_at_LL.MIT.EDU> forgy_at_ll.mit.edu (James Forgy) writes:
>In article <Csw32B.Ju7_at_Unify.com> jde_at_Unify.com (Jeff Evarts) writes:
>>From: jde_at_Unify.com (Jeff Evarts)
>>Subject: BIG Joins
>>Date: Wed, 13 Jul 1994 17:25:23 GMT
>>I`m curious... how many people out there know of a runtime environment
>>where a "common" operation on a database involves a join of more than,
>>say, 5 tables?
>I have wrote a 7-Way Join with a Union on a 600,000 row table and it only took
>7 seconds to run.
Unless I'm mistaken, a Union just lumps result sets together. I don't think its a join!
John Received on Fri Jul 15 1994 - 13:42:59 CEST