Level 2
i would go for one table. My reasoning being you dont have to query multiple tables if u need data about several states and its much easier to manage
hope i understood ur question nd the answer is helpful
Aug 28, 2018
1
Level 2
Create a new table or store in same
Ok, I have data about different persons. Lets' say people from different states. One states have around 10-15M rows of data. Now, here which one is suitable is it good to make each table for each state or to insert all data in same table.
Could you also explain me the pros and cons of both method.
Please or to participate in this conversation.