Analyzing File Structure with ISTAT

ISTAT produces a summary of the item distribution for a file and analyzes the structure of groups within the file. This item distribution summary can help you determine whether the current file structure is the best one for the file.

The following example shows the result of the ISTAT command run on the Master Dictionary of an account:

>ISTAT MD

FILE= MD MODULO= 7                   15:36:03  DD MMM YYYY

FRAMES BYTES ITMS

     1   1006  45 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1    595  28 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1    787  38 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1    898  42 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1    643  33 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1    862  45 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

     1   1219  49 *>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

  7

 

ITEM COUNT=    280, BYTE COUNT=  6010, AVG.BYTES/ITEM=  21.4

AVG.ITEMS/GROUP=40.0,STD.DEVIATION=7.4,AVG.BYTES/GROUP= 858.5

You can see that items are distributed evenly, with an average of 40 items in each group.

See Also

Tools for Checking File Efficiency

Testing File Structure with HASH-TEST