Re: SYSPARTITIONSTAT AVGROWSIZE -1

[Peter Dow <petercdow@xxxxxxxxx>]

That sounds about right - get something running quickly, that's at least 
somewhat useful.  As long as there are no varchar or lob fields, 
AVGROWSIZE seems to be the record length.

I haven't verified this, but DATA_SIZE seems to be the allocated size 
based on initial number of records and the record length, then gets 
additional space when it grows based on the increment number of records.

There was another field that said it was the number of 64K blocks 
allocated to the file, which really sounds like something for another 
system.


On 3/10/2021 4:04 AM, Rob Berendt wrote:
> I think SYSPARTITIONSTAT was copied from other platforms with the minimum amount of effort put into it.
> I also wondered about your calculation
>       AVGROWSIZE = DATA_SIZE / NUMBER_ROWS
> And how much it would vary between tables with a lot of rows and those with a minimum number of rows.  Like, does it do anything like allocate file space in blocks or some such thing?
>
> Rob Berendt