Query Index Analysis
Published 17 June 2025
SQL Prompt includes an Index Analysis feature, which evaluates the performance impact of different indexes on your query.
- To use this feature you must have SQL Prompt v11.05 or later, and internet connectivity.
- Your selected query is passed only to Redgate's analysis service and not any third party services.
- Queries are not retained by the service.
- No data is sent to the service.
- Your query is not visible to anyone, including Redgate employees.
Index Analysis supports SELECT queries that contain WHERE or JOIN clauses.
To analyze a query, right click over the query or highlight a query and select Analyze Query Indexes from the context menu.
This launches the Query Index Analysis tool window, which shows the hinted indexes alongside the existing indexes with their estimated impact.
Use the provided buttons to copy the SQL script to create each suggested index.
Considerations
- Index performance is simulated with uniform data distributions and predicted row counts, which are not based on the stats taken from your specific database. As such, performance may vary dependent on your environment.
- Analysis is only performed on non-clustered rowstore indexes.
- The feature may not be available to you
- if this isn't covered by your specific license
- if your organization has elected to opt out
Please contact Redgate Support if you have any questions.
