|
|
|
Forum Member
 
Group: Forum Members
Last Login: 4/30/2008 4:36:46 AM
Posts: 32,
Visits: 14
|
|
Hi All,
How to find the Rowsize of a tbl and a block size in an AMP ?
Regards, GogulM
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 6/20/2007 11:58:00 AM
Posts: 10,
Visits: 1
|
|
|
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.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 4/30/2008 4:36:46 AM
Posts: 32,
Visits: 14
|
|
THANK YOU VERY MUCH ... :-)
Regards, GogulM
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/5/2009 2:58:22 PM
Posts: 134,
Visits: 13
|
|
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
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/10/2007 6:21:00 AM
Posts: 2,
Visits: 1
|
|
|
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.
|
|
|
|