The table on which I am working has 126 columns and at least I have noticed that at least 50 There are columns. Will a table contain fewer columns per table or separate them into a new table and use the relationship?
What is the maximum number of columns per table in your experience? Does it affect the database with such designs?
Jack
Generally it is better to model and generalize data requirements To complete the rules of your design, first design your table then is concerned about optimization such as how many pages it takes to keep the line, etc.
I agree with other posters here that a large number of columns are an potential red flag which is not normalized in your table but in this case it can be cured. We can not tell from your details.
In any case, by dividing the table just because a large number of columns trouble you, it is not the right solution. Is it actually causing any defect or performance? Assume that you need to measure to ensure this.
Comments
Post a Comment