Performing an SQL Trace

Procedure


  1. Open a new window and choose Start of the navigation pathSystem Next navigation step Utilities Next navigation step Performance TraceEnd of the navigation path.

    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. Choose Trace Off to deactivate the trace. 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 detailed information. The index used is specified in the line beginning with Index.