Posted by MJKulangara on 02/02/06 22:54

By no means a "Guru"...but If I'm following you...

This is the age old question of "to normalize" or not to "normalize".

By splitting the tables you achieve a higher level of normalization.
This will cause queries etc to run somewhat quicker..but you wll take a
hit in terms of storage space.

By making one table...you will speed up your queries...but waste space.

HTH

MJKulangara
http://sqladventures.blogspot.com

[Back to original message]