Re: null columns and memory?

In memory where? Space is reserved in DB blocks (formerly via PCTFREE, now
via ASSM) for operations that increase the storage requirements of the
block--such as updating a character string to a longer string, or supplying
a value in a column that formerly contained none.


On 9/27/05, ryan_gaffuri@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx> wrote:
>
> 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?
>



--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx

Other related posts: