Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Do columns with Null data take up space?
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
![]() |
![]() |