Index suggestion
Suggest an index from the WHERE columns.
Processed in this browser. Nothing is sent to a server.
Result
How do I use Index suggestion?
Paste a SELECT.
What are the limits of Index suggestion?
It is a heuristic, not the database plan.
Related tools
- SQL minifierCollapse spaces and remove line comments.
- SELECT builderBuild a SELECT from fields.
- UPDATE generatorBuild an UPDATE and require WHERE.
- DELETE builderBuild a DELETE. Without WHERE it continues only when confirm is all.
- Table to JSONConvert a bar- or comma-separated table into JSON.
- JSON to SQLWrap JSON objects in INSERT statements inside a transaction.