storage requirements for numeric datatypes

From: d cheng <dc4oracle_at_yahoo.com>
Date: Tue, 13 Sep 2005 23:05:44 -0700 (PDT)
Message-ID: <20050914060544.50181.qmail@web34505.mail.mud.yahoo.com>

Hi listers,  

I am working on a sizing estimate for a one billion row table. This table will have ten numeric columns. Is there storage savings if the numeric columns were defined as NUMBER(12,2) versus NUMBER(22,7). Will the storage requirements depend on the actual numeric data values?  

Thank you in advance for your help!  

• David

  ---

Yahoo! for Good
 Click here to donate to the Hurricane Katrina relief effort.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 14 2005 - 01:07:45 CDT