Summarizing a SQL list and viewing table-related information
For each SQL statement in the program, the trace list shows a number of lines corresponding to the various operations, thus making the list very huge in size. We can see a summarized (view), and also apply table-related functions on the list values. In this recipe, we will see how to apply these functions.
How to do it...
For displaying summarized information, carry out the following steps:
From the SQL list, choose the menu option Trace List | Summarize Trace by SQL Statement. Alternately, you may use the keys Shift + F8.
In order to see a list of all identical selects within the trace, choose the menu option Display Identical Selects.
For generating a combined view for various table accesses and without the details of the SQL statement, use the menu option Trace List | Combined Table Accesses or use keys Ctrl + F8. You may also see an Aggregate table view from the Combined Table Accesses list, by using the menu path Table List | Aggregate...
