All Forums Database
GogulM 32 posts Joined 08/06
09 Sep 2006
RowSize and BlockSize

Hi All,
How to find the Rowsize of a tbl and a block size in an AMP ?

fxstein 10 posts Joined 05/06
10 Sep 2006

There is not ONE row-size in most tables. Do to NULL values, variable length fields and compression, every row will have a different length. To calculate the average row-size of a table simply divide the table size by the record count.

GogulM 32 posts Joined 08/06
11 Sep 2006

THANK YOU VERY MUCH ... :-)

Vinay Bagare 96 posts Joined 12/04
11 Sep 2006

fxstein

My understanding was compressed values are never part of Row. They are more part of the table header and they are always calculated as an Table Header overhead Vs Row. The row has its own overheads like presence bits, etc.
Yes, they do impact the row size as they are stored in the table header as against the row itself.

Correct me if my understanding is wrong in this regard.

Vinay

TechPurism 2 posts Joined 01/07
13 Jan 2007

Yes, a compressed value is not present in the row. I think the previous poster was saying that not all values will be compressed, so some rows will have a value for the field, and other rows will not have bytes for the field at all, and that therefore row size will vary even if all the fields are fixed length types.

You must sign in to leave a comment.