From oracle-l-bounce@freelists.org Tue Sep 27 15:17:58 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8RKHvqV032539 for ; Tue, 27 Sep 2005 15:17:58 -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 j8RKHj6H032478 for ; Tue, 27 Sep 2005 15:17:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4F2A1EEF3D; Tue, 27 Sep 2005 15:17:27 -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 27438-06; Tue, 27 Sep 2005 15:17:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4CDF11E0CA3; Tue, 27 Sep 2005 15:17:27 -0500 (EST) From: ryan_gaffuri@comcast.net To: oracle-l@freelists.org Subject: null columns and memory? Date: Tue, 27 Sep 2005 20:15:29 +0000 Message-Id: <092720052015.29170.4339A86100004DB8000071F22207001641079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="NextPart_Webmail_9m3u9jl4l_29170_1127852129_0" X-archive-position: 25960 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net 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=-2.2 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, MIME_BOUND_NEXTPART,MIME_HTML_NO_CHARSET,NO_REAL_NAME autolearn=no version=2.63 --NextPart_Webmail_9m3u9jl4l_29170_1127852129_0 Content-Type: text/plain Content-Transfer-Encoding: 8bit Someone at work told me the following. Having trouble confirming it in the docs. If you have a table with a nullable varchar column. If the field is left null no space will be taken up in the database. However, space will be reserved in memory for the column. Is this correct? --NextPart_Webmail_9m3u9jl4l_29170_1127852129_0 Content-Type: text/html Content-Transfer-Encoding: 8bit
Someone at work told me the following. Having trouble confirming it in the docs.
 
If you have a table with a nullable varchar column. If the field is left null no space will be taken up in the database. However, space will be reserved in memory for the column. Is this correct?
--NextPart_Webmail_9m3u9jl4l_29170_1127852129_0-- -- http://www.freelists.org/webpage/oracle-l