Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!sn-ams-06!sn-xt-ams-05!sn-post-ams-02!sn-post-ams-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Number of Columns in a table. Date: Fri, 03 Mar 2006 15:43:33 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1141429406.629424@jetspin.drizzle.com> User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1141309139.638174.293680@p10g2000cwp.googlegroups.com> <1141334405.604334@jetspin.drizzle.com> <1141334874.348719.69400@v46g2000cwv.googlegroups.com> In-Reply-To: <1141334874.348719.69400@v46g2000cwv.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: jetspin.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 27 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262758 milind.namjoshi@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@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@x.washington.edu (replace x with u to respond)