Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number of Columns in a table.

Re: Number of Columns in a table.

From: <milind.namjoshi_at_trans.ge.com>
Date: 2 Mar 2006 13:27:54 -0800
Message-ID: <1141334874.348719.69400@v46g2000cwv.googlegroups.com>

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 .
Received on Thu Mar 02 2006 - 15:27:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US