Performing an SQL Trace

  1. Open a new window and choose System ® Utilities ® SQL Trace.

    The Trace Requests screen appears.

  2. Choose Trace On to activate the trace.
  3. Perform a typical database access in the first window (for example, an application transaction or the transaction SE16).
  4. To turn the trace off, choose Trace Off and examine the SQL statement with List Trace.
  5. Position the cursor on one of the PREPARE, OPEN, or REOPEN statements, and choose Explain SQL.

The system displays detail information. The index used is specified in the line beginning with Index.