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