Hello all, Just wanted to know how many columns are preferable in table. At present we are having nearly 50 - 60 columns in some of the tables. Is this ok or should we be splitting the tables for normalization.
If we really need to split then how better would it be in terms of performance.? 1) Splitting into related tables would then require Joins for data retrieval 2) Inserts/ updates will have to be done on more than one table now It would be great to also know the best practices on number of rows that a table must hold. Ratheesh Bhat K J
