We need to add new fields to one of our tables but only a small subset of records will be impacted (or contain relevant values). I’m looking for some guidance about whether or not we should add the fields to the table or create a new table which will have a 1 to 1 relationship with the old table but only contain records where relevant data exists.
Current table has 2.5mm records, only about 50,000 records actually matter ( we may at some point clean it up ).
I need to add these fields to the table:
field1 ( varchar (40) )
field2 ( int, indexed )
field3 ( date )
field4 ( enum (‘value1’ (default), ‘value2’, ‘value3’, ‘value4’) )
field5 ( int )
field6 ( date )
Only 50,000 records or 2.5% will ever have data in the new fields. Does it make sense to add them to the current table or create a new table with a 1 to 1 join relationship?
Any suggestions / help is appreciated.