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.