Re: Do columns with Null data take up space?

"Doug" <douglas_at_igmax.com> wrote in message news:8eb5e9ba.0412021729.10ebca78_at_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?

either the concepts manual or dba manual will give specifics on row and block structure -- but as far a i can recall they take up a byte or two unless at the end of the row, in which case they take up no storage

++ mcs Received on Thu Dec 02 2004 - 21:10:30 CST