Show TOC

 Checking Index UsageLocate this document in the navigation structure

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

    The Trace Requests screen appears.

  2. Select Activate Trace.

    The SQL trace is activated for your user, that is, the system records all the database operations under your user.

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

    If your database system uses a cost-based optimizer, you have to 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 Deactivate Trace and then Display Trace.

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).