From oracle-l-bounce@freelists.org Wed Sep 14 01:07:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8E67jA0019003 for ; Wed, 14 Sep 2005 01:07:45 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8E67e6H018987 for ; Wed, 14 Sep 2005 01:07:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED42E1EBFD2; Wed, 14 Sep 2005 01:07:35 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31541-01; Wed, 14 Sep 2005 01:07:35 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6AA411EBE99; Wed, 14 Sep 2005 01:07:35 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ECPL9kNjNLTPE3WJgfWQ1cafrIYCzvDbGjODivKjDeuaztS2pBSP39/1lgPffb9iQLU7IX8ainoZF0fAgYWRkAJZS9t8V6KV2GE2dOY8ejvo9Crj1OgK+WnPTsiT/DMAwtv6RIxjc4kKvPAUmL6VOfaB4v3jcEgPKjQl7nX2BJk= ; Message-ID: <20050914060544.50181.qmail@web34505.mail.mud.yahoo.com> Date: Tue, 13 Sep 2005 23:05:44 -0700 (PDT) From: d cheng Subject: storage requirements for numeric datatypes To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2132809830-1126677944=:49057" X-archive-position: 25404 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dc4oracle@yahoo.com Precedence: normal Reply-To: dc4oracle@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.8 required=5.0 tests=AWL,BAYES_00,CLICK_BELOW, FORGED_YAHOO_RCVD,HTML_LINK_CLICK_HERE,HTML_MESSAGE autolearn=no version=2.63 --0-2132809830-1126677944=:49057 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-2132809830-1126677944=:49057 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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. --0-2132809830-1126677944=:49057-- -- http://www.freelists.org/webpage/oracle-l