Re: storage requirements for numeric datatypes
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: dc4oracle@xxxxxxxxx
- Date: Wed, 14 Sep 2005 10:09:57 +0300
Detailed description of NUMBER datatype is available here
http://www.ixora.com.au/notes/number_representation.htm
Yes, the actual consumed space for NUMBER datatype will depend on the
actual data.
If you are going to store floating point values, you can consider
using binary_float or binary_double. This datatypes represent standard
IEEE float values and are 5 and 9 bytes long (extra byte is consumed
by datatype). This datatypes are very useful if you need to store
operational data or scientific data, and you can tolerate binary
precision.
Datatypes are available from 10g, you can read more about them:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref95
On 9/14/05, d cheng <dc4oracle@xxxxxxxxx> wrote:
> 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.
>
>
--
Best regards,
Edgar Chupit
callto://edgar.chupit
--
//www.freelists.org/webpage/oracle-l
Other related posts:
