Displaying the access path while monitoring an application or thread

This topic shows how to view the access path while monitoring an application or thread.

To view the access path:
  1. Open the Thread Details window.
  2. In the folders pane, click SQL Statement.

    The SQL Statement pane shows the SQL statement that is currently run by the thread. The Explain button is enabled.

  3. Under SQL statement text, click Explain. If the statement contains a SELECT, UPDATE, INSERT, DELETE, or VALUES clause, Query Workload Tuner is opened to view the access path for this statement.
Note: Usually only one of the Explain products is started at the same time. (This depends on the data bridge server connection that is used.) You can also cut and paste the SQL statement text from Performance Expert Client to manually create a project.