Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: conserving space...
Yes, but you are only saving 1 byte per column. If you have 5 columns and
the last 4 can be null then if they are null you will save 4 bytes. If one
of them is not all the preceding columns will have a byte in them to
indicate that they are null for that row. So if the column for that row is
empty it does not take up the data size (so a varchar2(255) empty column
takes up at most 1 byte).
Jim
jayvee_at_mayon.cats.edu.ph wrote in message
<77e4hr$jv1$1_at_nnrp1.dejanews.com>...
>Hi,
>
>Is it true that in order to save space for nullable columns, it
>must be located at the bottom of the create statement?
>Why?
>
>Thanks...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 12 1999 - 07:38:03 CST
![]() |
![]() |