storage requirements for numeric datatypes

  • From: d cheng <dc4oracle@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Sep 2005 23:05:44 -0700 (PDT)

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. 

Other related posts: