of use you could just whack columns galore in a table (until row size) but
if you are truly relational a 4-5 table join is perfectly acceptable...BUT
if you are finding that you can eliminate entirely table/s from a join then
you will need to address your schema... try using Super / Sub-Type db
design to eliminate unnecessary joins and see if you can 'adhere' to at
least a few of the Codd rules of Database design.....
_____
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: 19 July 2004 16:05
To: SQL
Subject: Space vs. Joins
Lets say that a join has to be made between 4 or 5 different tables.
Two or three of these tables can be avoided by creating a column or
two in one table. These columns will usually be blank. Is it better to
have more, tighter tables and join them or to make fewer tables with
more columns even if one of those columns may not have much data?
Not worrying about space, just speed.
Let the debate begin. :)
--
Michael Dinowitz
http://www.houseoffusion.com
For all your ColdFusion needs
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
