On 21-5-2018 08:09, hugo.lar...@yahoo.com [firebird-support] wrote:
> I have a followup question.
> If I have a varchar(1000) column with 1000 characters in it and then i
> delete the value in only that column but keep the row. The row has other
> columns with values.
> Will the space be reclaime
Hi,
I have a followup question.
If I have a varchar(1000) column with 1000 characters in it and then i delete
the value in only that column but keep the row. The row has other columns with
values. Will the space be reclaimed and overwritten?
BR,
Hugo
27.02.2018 06:42, hugo.lar...@yahoo.com [firebird-support] wrote:
>
> Does null values take up disk space?
Yes, but much less than the declared column size.
> If I have a table with 4 VARCHAR columns and I add 4 more does the table
> need double space even if the new columns are null?
Already