Review index suggestions for slow queries

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.

시작하기 전에

Role required: admin

이 태스크 정보

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

프로시저

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.

   옵션	설명
   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.