Entering content frameProcedure documentation How to Check if an Index is Used Locate the document in its SAP Library structure

Procedure

  1. Open a second session and choose System ® Utilities ® Performance trace.

    2. The Trace Requests screen appears.

  2. Select Trace on.

    3. The SQL trace is activated for your user, that is all the database operations under your user are recorded.

  3. In the first window, perform the action in which the index should be used.

    4. If your database system uses a cost-based optimizer, you should perform this action with as representative data as possible. A cost-based optimizer tries to determine the best index based on the statistics.

  4. In the second session, choose Trace off and then Trace list.

Result

The format of the generated output depends on the database system used. You can determine the index that the database used for your action with the EXPLAIN function for the critical statements (PREPARE, OPEN, REPOPEN).

Leaving content frame