Command statistics
For each SQL statement (package section) ever executed, SQL/MF automatically
maintains in its SQL_Statements table:
-
the text of the statement
-
the statement's access path
-
the selectivity of index access
-
all statistical counters captured during the last execution of the statement
The SQL_Statements table can be accessed at any time, from the SQL/MF
user interface program, to inspect the latest execution statistics for any SQL statement.
Sample Statistics
Report