January 22, 2005 at 6:00 am
I would like to get a general opinion from people on the maximum number of columns that should be put into a table.
We have a table in one of our databases that has 245 columns in. My own opinion is that this is fairly excessive for a single table and that the table should probably really be broken down into more managable one-to-one tables.
It would be interesting to hear other peoples views on this and/or if anyone has tables in their database of a similar (or larger) size.
Also, does anyone happen to know if there is a maximum column limit on a single table and if so what it is?
Gary
January 22, 2005 at 1:37 pm
There is actually a limitation on columns in a table: 1024. So, way to go here. Generally I would agree with you, that 245 columns are pretty much for a single table and should be reviewed for optimization. But this depends to a certain degree on your specific environment, on which you can judge yourself best.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 23, 2005 at 5:31 pm
245 columns in one table ?!?!? Well maybe a shot a normalization (breaking things up into a few tables) just might be in order. Not attempting to do this might well be a disservice to your client/business and to yourself as a DBA (not to mention the potential issues you may find down the raod later).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply