Kbase P24485: How do I find the number of records per block for a table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How do I find the number of records per block for a table?
FACT(s) (Environment):
Progress 9.x
FIX:
For this you need to know
1. in which area the table resides
2. how many records per block is defined for that area.
The report produced by "proutil <dbname> -C dbanalys" will show the storage areas for all tables and indexes.
Within the file <dbname>.st (updated when running "prostrct list <dbname>"), you have the number of records per block in each area.