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?
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?
