Re: BIG Joins

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?
 

>It seems to me this is fairly rare, limited mostly to large reports
>that would get spooled off at EO[DWMY].
 

>Have YOU ever written one?
>Was it a one-shot or something intended for repeated use?
>What was it for?

Of course I have written them. Sometimes you have to join a table to itself and then suddenly are faced with maybe three look-up tables and some outer-join logic that involves two more 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.

-jf

>I`m summarize to these newsgroups.
 

>-Jeff Evarts
>--jde_at_unify.com
Received on Wed Jul 13 1994 - 23:38:11 CEST