Generate an index suggestion for a slow query
-
- UpdatedJan 30, 2025
- 2 minutes to read
- Yokohama
- Platform Performance
Use the Index Suggestion Engine (ISE) to generate an index suggestion for a slow query. The ISE analyzes slow queries and provides index recommendations to improve execution time when possible.
Before you begin
Role required: admin
About this task
When the ISE generates an index suggestion for a slow query, it reviews query metrics and information from tables in the query. If the ISE doesn’t have the information required to generate an index suggestion, the system displays messages informing you about the data needed. These messages typically provide links for obtaining more information, such as updated query metrics or gathering column statistics from tables in the query. Sometimes the ISE might be unable to provide a recommended index for the query and lets you know why the suggestion can’t be generated.
Procedure