milind.namjoshi_at_trans.ge.com wrote:
> I have an entity which has got 900 Attributes. All the attributes are
> of type number(15).
> How do i store it ?I do not want to normalize it as it consumes more
> space and affects query performance.
> Is it recommended to store in a single table with 900 columns. My max
> rows size will be 10K and we are using block size of 16K.
>
> Are there any guidelines which says on how many columns and under what
> circumstances ?
Store nothing. Redesign based upon sound principles of normalization.
900 attributes should likely be stored in two columns as a name/value
pair.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Mar 02 2006 - 15:20:11 CST
