SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
F-22
STATISTICS Display
STATISTICS Display
This figure shows the STATISTICS display.
The fields in the STATISTICS display are:
Examples—FILEINFO
For these examples, assume that the subvolume $VOL1.INVENT contains only catalog
files and these files (see if this is ok), and that all SQL objects are defined in the
catalog $VOL1.INVENT:
TOTAL TOTAL AVG # AVG AVG %
LEVEL BLOCKS RECS RECS SLACK SLACK PART
1 1 1 1.0 4065 99 $VOL1
DATA 1 1 1.0 4046 99
FREE 0
BITMAP 1
LEVEL Indicates the tree level of the entry:
DATA Data level (this is the only level shown for relative
and entry-sequenced files)
n Number of level with 1 as lowest level (for
key-sequenced files)
The remainder of the fields in the line apply to the
indicated level.
TOTAL BLOCKS The total number of blocks in use.
TOTAL RECS The total number of records. At the DATA level, TOTAL
RECS is the total number of data records in the file.
AVG # RECS The average number of records per block.
AVG SLACK The average number of unused bytes per block.
AVG % SLACK The average percent of unused bytes for each block.
PART For partitioned files, the volume name of the partition
associated with the entry.
FREE TOTAL BLOCKS For key-sequenced files, the total number of unused
blocks from the beginning to the EOF.
FREE TOTAL RECS For relative files, the total number of empty records from
the beginning to the EOF.
BITMAP TOTAL
BLOCKS
For relative and key-sequenced files only, the number of
bitmap blocks.
ESTABLE An unpartitioned, entry-sequenced table
PARTLOC A partitioned, key-sequenced table
PARTLOCI An index defined on PARTLOC