Thread: Design of the table
05-16-14, 04:19 #1Registered User
- Join Date
- Apr 2013
Unanswered: Design of the table
I have a 33 columns in my table (in accordance with the normalization, describe one thing). But only 16 of them, every time I complete. Technically I can split this table to two tables. So the questions are:
1) What is better for performance. To Have a one table? Or split to two tables with realtions (16 - first table, 17 second table)?
2) If I fill 16 fields to describe some order, Ms Access uses space for 16 fields or all 33 fields?
05-16-14, 05:17 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
is their a performance problem?
is their a security problem?
...both of those could be reasons for splitting a normalised table into two tables using a one to one link
as to whether you are consuming too much space, by having say too many NULL columns, I doubt it.,
however there could be another reason for splitting the tables, and that is if the 17 coulmns are in effect a sub type of the first 16 columns... look up super/sub type modelI'd rather be riding on the Tiger 800 or the Norton