nulls in varchar and char columns, how much space?
I am going to have several tables that will have several columns that will be varchars and will be sparcely populated. I am trying to determine sizing on these tables. doing a show table status doesn't help it shows size as zero with nulls being populated and looking at ndb_size.pl it does an avg(length()). that doesn't do me any good either. So if i have a table that is
a varchar(255)
b char(1)
c varchar(255)
and a cannot be null, but b and c can be.
how do i size this row if b and c are null? is it zero? i imagine there is some overhead for each value in each row for the varchars.
Edited 1 time(s). Last edit at 05/31/2006 12:23PM by richard horan.
Subject
Views
Written By
Posted
nulls in varchar and char columns, how much space?
2117
May 31, 2006 11:56AM
1243
June 12, 2006 11:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.