I have a problem where all the data except one column, which is known to have 4 different values, will be a variable.
Other than that column everything else will be of same type(only column names are same but data will be different)
For smaller applications I hope it is OK to just add the flag and make it one table.
I will be working with data containing around 100,000 rows and increasing everyday at the below ratios. If split they will be like
Type 1 - 60,000 Type 2 - 20,000 Type 3 - 10,000 Type 4 - 10,000
I want a better way to implement especially on MySQL but information about Oracle is much appreciated as I want to gain knowledge in that too.
What happens if I add this to a single table and make the type as index so the burden for where conditions will be low?
How comparable is that to having 4 different tables?
Personally, I don't like the idea of 4 tables but I am looking for an answer in performance perspective.