Kbase P6975: How to get the average records size of a table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/02/2011 |
|
Status: Verified
GOAL:
How to get the average record size of a table
GOAL:
How to calculate the average records size of a table
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Use proutil ?C tabanalys and proutil ?C dbanalys to get the statistics information of record sise.
The report will show the mean (average), minimum and maximum size of the records of a table.
Programmatically, the same information can be retrieved using 4GL functions such as RECORD-LENGTH, see solution P151842, "How to find the length, in bytes, of each record of a Progress / OpenEdge Database table?".