Database Design Questions

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 two columns?

Questions by Muhammad Khan

Showing Answers 1 - 6 of 6 Answers

Asiimwe

  • Jan 2nd, 2016
 

Its not good to separate them.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions