Schedule an index suggestion for creation

Use the Index Suggestion Engine (ISE) to schedule an index suggestion for creation.

Before you begin

Role required: admin

Procedure

  1. Navigate to the index suggestion for the slow query:
    LocationDescription
    From the Application Navigator Navigate to System Diagnostics > Index Suggestions > Index Suggestions > To review.
    From the Performance homepage If the suggestion icon has a number (Lightbulb icon for index suggestion), click the icon to open the Suggested Indexes window, and click View all suggested indexes.
    Note: In the Suggested Indexes window, you can click View next to a specific table to open its index suggestion record.
  2. In the Index Suggestion table, click the Table Name for which the index is to be created.
  3. In the Index Suggestion form, click Schedule Creation.
  4. In the Schedule Index Creation window, select the time that the index is to be created and click Create. You can schedule index creation later when your instance is less busy.
    Note: If the index to be created involves large tables, such as the Incident or CMDB table, index creation may take up to one hour or longer.
    scheduler for index creation
    • Create now - The Schedule Index Creation progress indicator window shows the progress of the index creation. When index creation is complete, click Close.
      Schedule Index Creation progress indicator showing index was created successfully
    • Create later - If you select this option, the state changes to Create Scheduled, and the index is created at the scheduled time. After the index is created, the index state changes to Evaluating Effectiveness.

    When the ISE creates the index at the selected time, it assigns an index name based on the tables used in the slow query.

  5. Verify that the index was created by reviewing the index State in the Index Suggestion record or in the Index Suggestion table (System Diagnostics > Index Suggestions > Index Suggestions > In Progress).
    The Index Suggestion record shows the state, Evaluating Effectiveness. The ISE begins the 14-day index evaluation period.
    Index Suggestion record that shows index is in the evaluation state
  6. During the evaluation period, you can monitor the index State in the Index Suggestion record or in the Index Suggestion table (System Diagnostics > Index Suggestions > Index Suggestions > In Progress).