Multiple vs Single Table

danya

New Member
I have an issue different from the questions already on stackoverflow.We have two entities representing "Foo USA" and "Foo World", while the columns of Foo are exactly the same in both the tables, there would not be a scenario where these two tables would need to be joined and retrieved, they are completely independent of each other by their definition.Does it make sense to keep two tables separate only because they define two exclusive entities? Does keeping the data in small independent tables yield better performance?Please help and thanks for looking.
 
Top