Review index suggestions for slow queries

  • Release version: Australia
  • Updated June 11, 2026
  • 1 minute to read
  • You can review index suggestions and indexes created by the Index Suggestion Engine (ISE). The ISE provides three main views of index suggestions as they move through their life cycle: index suggestions in review, index in progress, and index done.

    Before you begin

    Role required: admin

    About this task

    Access index suggestions from the Application Navigator or the Performance homepage.

    Procedure

    1. Access the index suggestions for your instance by navigating to System Diagnostics > Index Suggestions > Index Suggestions > To review.
    2. In the Index Suggestions table, select the table associated with the index suggestion you want to view from the Table Name column.
    3. Review the index suggestion for the selected table.
      For a description of the field values in the index suggestion, see Index suggestion form fields.
    4. Choose the next processing step for the index suggestion.
      OptionDescription
      Export Downloads the index suggestion as an .xml file, which can be exported to a non-production instance for testing and evaluation.
      Ignore Changes the index suggestion state to ignore, which indicates the index suggestion is no longer active and available for index creation. Index suggestions with an Ignore state are listed in the Index Suggestions > Done view of the Index Suggestion table.
      Schedule creation Opens the Schedule Index Creation window to schedule an index suggestion for creation.