Re: Number of Columns in a table.

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 03 Mar 2006 15:43:33 -0800
Message-ID: <1141429406.629424@jetspin.drizzle.com>

milind.namjoshi_at_trans.ge.com wrote:
> DA Morgan wrote:
>
>

>>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)

>
>
> I would have loved to do that. This increases my storage requirements
> by 5 times.

>>From 5 Tera bytes to 25 Terabytes and makes my queries more complex .

Not possible: Bytes are bytes are bytes. Whether stored horizontally or vertically. Even on Teradata.

Show the the DDL.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Mar 03 2006 - 17:43:33 CST