I have a database with 5 millions records, i have Person table having 5 million records and its have 13 columns. Forename and surname column is heavily populated as compared to other columns. My question is it appropriate to separate forename and surname column and make separate tables for it and reference it with id in person_detail table. What are the advantages and disadvantages in separating these...

prakash

• Mar 9th, 2019

Advantage: Size of the table will decrease and so the query performance will be improved.
Disadvantage: Join query will be required to get surname and full name of person.

Asiimwe

• Jan 2nd, 2016

Its not good to separate them.

Answer Question  Select Best Answer