View Full Version : more than 50 fields in a table ??

03-20-2007, 07:52 AM
Hello forums!!
I had made a table which contains more than 50 fields..
I am afraid this will hamper later ..

What i want to know ?
1>how many fields should be in a table for optimization ?
2>what should taken into consideration for future hazards in case there are more than
50 fields in table ?

I would really appreciate the answers from you
Thanks in advance to all of you !!

03-20-2007, 10:45 AM
Have you considered whether normalisation is an option? What are the 50 fields, I cant think of many situations where I would need 50 fields in a single table.

03-20-2007, 07:49 PM
Usually normalizing the table to at least third normal form should produce the optimum arrangement of the data into tables. 4th, 5th, and Boyce-Codd normal form only apply in certain situations anyway while the first three normalizations always apply.

There may be rare occasions where you undo a small part of the normalization and duplicate data to significantly speed up processing.

It would be just about impossible to have a situation where normalizing the data will leave you with anywhere near 50 fields for the same table. In most cases where you have that many fields there will either be repeating groups or cross field dependencies to be normalized out into separate tables.