Generating and interpreting the trace result
In this recipe, we will generate the results of the trace carried in the previous recipe, Carrying out SQL trace. The mentioned recipe should be completed in order to proceed with this one. We will then interpret the results in order to get a better idea of the various tables and their access times involved.
How to do it...
We will now carry out the following steps:
From the main screen of the transaction
ST05, click on the Display Trace button. This will take you to the screen, as shown in the following screenshot:
The User name field and the Date and Time fields appear by default. You may change the Date and Time fields, and also enter data in the other fields if desired.
Then press F8. This will display the Performance Trace.
How it works...
When the Display Trace option is chosen, the performance trace is displayed. All the database activities (database access and database update statements) that were recorded during the time between the trace on...
