I have a table with 48 columns in it. Most of the data is specific to each primary key, but there are several binary fields that could be pulled out and put into their own table, containing just the PK from the table where a specific binary field is true.
With a small dataset (3000 records, 1.5MB data length) with expected growth of ~1000 entries per year, does it matter?
With a small dataset (3000 records, 1.5MB data length) with expected growth of ~1000 entries per year, does it matter?