View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 06:16 PM
MJKulangara
 
Posts: n/a
Default Re: Performance and data structure question

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

Reply With Quote