It is very strange you ask 'Is it recommended to store in a single
table with 900 columns' because you know the obvious answer. The
obvious answer is to normalize your design.
Also, you will get only 1 record per block, so I don't know what is
going to take more space.
And probably, as likely you are going to have chaining, you are going
to regret the day you implemented this disaster at all.
Also, recently there have been people experimenting with the order of
columns, and they noticed it actually *did* matter.
Finally: Oracle was originally handling 255 columns per table, and
needed an internal kludge to extent that to 1024.
The only guideline there is, is the common sense guideline to make sure
your design is in Third Normal Form. Any other guideline ends up in
stupidity.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Mar 02 2006 - 08:41:29 CST
