SQLAI.ai
Frequently asked questions
Go back
What does this generator do?
AI analyzes and optimizes the SQL query and suggestions database indexes to improve query performance.
Can I see what has changed?
Yes, you can click the "View diff" in the action drop down above the fixed SQL query. This shows a side by side comparison with the specific changes.
Usage tips for best results?
Use
AI model GPT-4
, set target
database engine
, and ensure language is set to English.
Optimize 1 query at a time (and only add the SQL query, not other unrelated data)
Re-run the optimizer a few times if first result isn't satisfactory.
If the query contains lots of "static" data, e.g. long array of ids, try to limit those and re-run. Afterwards you can easily fill in the static data.