Re: BIG Joins
Date: Mon, 18 Jul 94 12:16:09 -0400
Message-ID: <9407181216.PN01125_at_LL.MIT.EDU>
In article <305so3$50k_at_panix.com> janest_at_panix.com (John Anest) writes:
>From: janest_at_panix.com (John Anest)
>Subject: Re: BIG Joins
>Date: 15 Jul 1994 07:42:59 -0400
>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
Your thoughts don't change reality, you can have a union of many joins...of course if I took the union out it would run faster.
-jf Received on Mon Jul 18 1994 - 18:16:09 CEST