Hi

How to determine how many records contribute to a page in a table
( provided the structure of the table and pagesize ).

On Oct 29, 5:21 am, Sivaswami Jeganathan <sivaswamim... at (no spam) gmail.com
wrote:

Hi

How to determine how many records contribute to a page in a table
( provided the structure of the table and pagesize ).

You can look at avgrowsize in syscat.tables. That gives you average
row size and you have the page size. Now you can do the
mathematics . That should give you approx number of rows/page. Of
course, it depends on lot of other things and this is just an
approximation.