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. Before you beginRole required: admin About this taskAccess index suggestions from the Application Navigator or the Performance homepage. Procedure Access the index suggestions for your instance: LocationDescription From the Application Navigator Navigate to System Diagnostics > Index Suggestions > Index Suggestions > To review. From the Performance homepage If the suggestion icon indicates that one or more index suggestions are available, (), click it to open the Suggested Indexes window, and click View all suggested indexes. Note: In the Suggested Indexes window, click View next to a specific table to open its index suggestion record in the Suggestion Details—Add Index form. This form is the same as the Index Suggestion form described later in this task. In the Index Suggestions table, click the Table Name associated with the index suggestion you want to view. Review the index suggestion for the selected table. Table 1. Index Suggestion fields Field Description Slow query The slow query for which the index suggestion was generated. Example An actual SQL statement for an individual query, before being canonicalized to aggregate it with similar queries. Table name Name of the table used in the query. Column names Names of the columns used in the query. Index name Name of the index, assigned by the ISE after the index is created. State Processing state of the index. For details, see the Index suggestion states table. Imported This box, if checked, indicates that the index suggestion was imported from a different instance for evaluation and testing. 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 sub-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. Related TasksGenerate an index suggestion for a slow queryExport an index suggestion to a sub-production instanceSchedule an index suggestion for creationTest index performanceSchedule an index to be dropped
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. Before you beginRole required: admin About this taskAccess index suggestions from the Application Navigator or the Performance homepage. Procedure Access the index suggestions for your instance: LocationDescription From the Application Navigator Navigate to System Diagnostics > Index Suggestions > Index Suggestions > To review. From the Performance homepage If the suggestion icon indicates that one or more index suggestions are available, (), click it to open the Suggested Indexes window, and click View all suggested indexes. Note: In the Suggested Indexes window, click View next to a specific table to open its index suggestion record in the Suggestion Details—Add Index form. This form is the same as the Index Suggestion form described later in this task. In the Index Suggestions table, click the Table Name associated with the index suggestion you want to view. Review the index suggestion for the selected table. Table 1. Index Suggestion fields Field Description Slow query The slow query for which the index suggestion was generated. Example An actual SQL statement for an individual query, before being canonicalized to aggregate it with similar queries. Table name Name of the table used in the query. Column names Names of the columns used in the query. Index name Name of the index, assigned by the ISE after the index is created. State Processing state of the index. For details, see the Index suggestion states table. Imported This box, if checked, indicates that the index suggestion was imported from a different instance for evaluation and testing. 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 sub-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. Related TasksGenerate an index suggestion for a slow queryExport an index suggestion to a sub-production instanceSchedule an index suggestion for creationTest index performanceSchedule an index to be dropped