Index Advisor
v1.1.1Analyze SQL queries and suggest indexes to improve query performance.
Analyzes SQL queries and suggests indexes to improve performance — identifies full table scans, high-cardinality WHERE columns, and JOIN predicates that would benefit from an index.
How to use- →Paste a SQL SELECT query and optionally describe your table structure.
- →The advisor suggests CREATE INDEX statements with explanations for each recommendation.
- →Review suggestions before applying — composite indexes have ordering trade-offs.