Sorts performed

The number of sorts performed as the result of an SQL statement (the result of processing the ORDER BY clause)

Add additional indexes or sorted constraints to reduce the number of sorts

Maximum rows sorted

The largest number of rows sorted as the result of an ORDER BY clause

Add additional indexes to eliminate the sort

AM recompiles

The number of times access modules were automatically recompiled at runtime because of a recompilation of the corresponding program or dialog, or because of a change in the underlying database definition.

Examine the cause of compilations. If necessary, move frequently altered tables to areas with table level stamp synchronization.