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
Navigation:
[Reply to this message]
|