Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: Join Contest
Message-ID: <933@dgis.dtic.dla.mil>
Date: 16 Jul 90 23:31:09 GMT
References: <5265@plains.UUCP>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 15

gus@plains.NoDak.edu writes:

>Recently I heard that an IBM-type db person claimed that it's
>not uncommon in commercial db applications to join as many as
>10-15 (maybe even 30) tables in a single query.

It is uncommon.  Ask your IBM-type db person to substantiate
his claim.  "Extraordinary claims require extraordinary
justification".  In fact it's difficult to design a query that
makes sense with more than about five joins.  Try it.

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Drop in next time you're in the tri-planet area!