Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Do columns with Null data take up space?

Do columns with Null data take up space?

From: Doug <douglas_at_igmax.com>
Date: 2 Dec 2004 17:29:08 -0800
Message-ID: <8eb5e9ba.0412021729.10ebca78@posting.google.com>


If I create a table with 250 columns, and only fill 8, do the other columns take up space? (My user wants to log tests. There can be as many at 250 tests in a set, but normally only about 8. My user wants one record per set so he can run some third party analytical software against the test results.) Is Oracle 8i smart enough to compress the null values down so they don't take up space if they are unused? Received on Thu Dec 02 2004 - 19:29:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US