RE: BIG Joins

In Article <Csw32B.Ju7_at_Unify.com>
jde_at_Unify.com (Jeff Evarts) writes:
>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 wrote a customer information system that was fully normalized, and 5+ way joins were common. The more normalized your design, the more joins you do. Lots 'o work tuning, but even with tables of 1,000,000 rows you can get decent response.

ed

Ed Delaney                                   | Internet:
Assoc. Dir. of Administrative Computing      |   edwardd_at_yin.earlham.edu