Data & SQL21 categories
Will this query use my index?
You added an index and the plan still shows a sequential scan.
Will this query use the index below? If not, say what defeats it: a function on the column, a cast, or a leading wildcard. Query: Index:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Making queries faster. Diagnosing a slow query, reading the plan, and finding the smallest index that fixes it.
Related prompts
Make this slow query fasterA query that used to be fine now takes minutes.What index should this query have?A query does a sequential scan and you want the smallest index that fixes it.Read this query plan with meYou have an EXPLAIN output and no idea which line is the problem.Why is this query slow?A query got sluggish and you want one lead, not a checklist.Explain this query to me line by lineYou inherited a 200-line query and need to understand it before changing it.Write the query from a plain-language questionYou know exactly what you want to know and not how to express it in SQL.
Keep this one
Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free