Displaying Command Statistics

How to:

Reference:

The ? STAT command lists statistics for the most recently executed command.

Each statistic applies only to a certain command. If another command is executed, the statistic is either 0 or does not appear in the list at all. When you execute commands in stored procedures, these statistics are automatically stored in Dialogue Manager statistical variables. See your Dialogue Manager documentation for details.

Syntax: How to Display Command Statistics

To display command statistics, issue the command:

? STAT

Example: Displaying Command Statistics

Issuing the command

? STAT

produces information similar to the following:

                   STATISTICS OF LAST COMMAND 
RECORDS        =     0           SEGS DELTD      =     0 
LINES          =     0           NOMATCH         =     0 
BASEIO         =     0           DUPLICATES      =     0 
SORTIO         =    47           FORMAT ERRORS   =     0 
SORT PAGES     =     0           INVALID CONDTS  =     0 
READS          =     0           OTHER REJECTS   =     0 
TRANSACTIONS   =     0           CACHE READS     =     0 
ACCEPTED       =     0           MERGES          =     0 
SEGS INPUT     =     0           SORT STRINGS    =     0 
SEGS CHNGD     =     0           INDEXIO         =     0 

INTERNAL MATRIX CREATED:   YES     AUTOINDEX USED: NO 
SORT USED:               FOCUS     AUTOPATH USED:  NO 
AGGREGATION BY EXT.SORT:    NO     HOLD FROM EXTERNAL SORT: NO

Reference: ? STAT Query Information

The following information displays:

RECORDS

Is for TABLE, TABLEF, and MATCH commands. It indicates the number of data source records used in the report. The meaning of a record depends on the type of data source used.

LINES

Is for TABLE and TABLEF commands. It indicates the number of lines displayed in a report.

BASEIO

Is for TABLE and TABLEF commands. It indicates the number of I/O operations performed on the data source.

SORTIO

Is for TABLE, TABLEF, and MATCH commands. It indicates the number of I/O operations performed on the FOCSORT file, which is a work file invisible to the end user.

SORTPAGES

Is for TABLE and TABLEF commands. It indicates the number of physical records in the FOCSORT file.

CACHE READS

Is the number of cache reads performed. For details, see CACHE.

MERGES

Is the number of times that merge routines were invoked.

SORT STRINGS

Is the number of times that the sort capacity was exceeded.

INTERNAL MATRIX CREATED

Indicates how report sorting was handled. If an external sort handled it entirely, the value is NO. If both the application and an external sort handled it, the value is Y.

SORT USED

Is the type of sort facility used. It can have a value of FOCUS, EXTERNAL, SQL, or NONE. NONE means that the report did not require sorting.

AGGREGATION BY EXT. SORT

Uses external sorts to perform aggregation.

AUTOINDEX USED

Automatically takes advantage of indexed fields to speed data retrieval.

AUTOPATH USED

Selects an optimal retrieval path for accessing a data source.

HOLD FROM EXTERNAL SORT

Creates hold files with an external sort.