Alex Rivera | Logout

Is there a performance decrease if there are too many columns in a table?

Asked 2010-08-13T07:44:21.853
44

Is there a performance cost to having large numbers of columns in a table, aside from the increase in the total amount of data? If so, would splitting the table into a few smaller ones help the situation?

Edit
Report

1 Answer

2

Beyond performance, DataBase normalization is a need for databases with too many tables and relations. Normalization gives you easy access to your models and flexible relations to execute diffrent sql queries.

As it is shown in here, there are eight forms of normalization. But for many systems, applying first, second and third normal forms is enough.

So, instead of selecting related columns and write long sql queries, a good normalized database tables would be better.

answered 2010-08-13T07:57:44.740

Your Answer