Sorting
This topic explains how to sort events in a summarized report or trace.
They can be sorted by:
- Average elapsed time
- Average TCB time
- Default
- Exits
- Exit time
- I/O requests
- I/O time
- Lock suspensions
- Lock suspension time
- Number of scans
- Pages scanned
- Records sorted
- Rows processed
- Sort workfiles
If DEFAULT is used, the sort order is dictated by the summarization,
as follows:
- Cursor
- Sorted in alphabetical order within program
- Occurrence
- Sorted in timestamp order (trace default)
- Program
- Sorted in alphabetical order of package or DBRM name (report default)
- Statement number
- Sorted in numerical order within program
- Statement type
- Sorted in alphabetical order.