Path: utzoo!attcan!uunet!ns-mx!iowasp.physics.uiowa.edu!maverick.ksu.ksu.edu!ux1.cso.uiuc.edu!brutus.cs.uiuc.edu!wuarchive!psuvax1!psuvm!cunyvm!ndsuvm1!plains!gus@plains.NoDak.edu From: gus@plains.NoDak.edu Newsgroups: comp.databases Subject: Join Contest Message-ID: <5265@plains.UUCP> Date: 12 Jul 90 22:53:37 GMT Sender: gus@plains.UUCP Lines: 10 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. This seems like an incredible number of joins, especially if the tables are large, on the order of 1/2 million tuples. Any comment/references, etc.?