× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2021

Re: SYSPARTITIONSTAT AVGROWSIZE -1

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.