SQL query optimizer for Aiven for MySQL®

Use Aiven's AI-powered SQL query optimizer to get optimization recommendations for your SQL queries.

If you're running an Aiven for MySQL® service, you can also use Aiven's automatically generated suggestions for slow queries. In the Aiven Console, go to your service and click AI insights.

To optimize a query:

1. Click Tools > SQL query optimizer.
2. Click Optimize a query.
3. Select Aiven for MySQL® as the database type.
4. Enter your query and click Next.
5. Optional: To improve the suggestions, submit the schema structure and statistics:
   1. Copy the query in Schema structure and statistics and execute it in your database.
   2. Paste the query output in Query output.
6. Click Optimize.

Related pages

• AI database optimizer for Aiven for MySQL®
• SQL query optimizer Aiven for PostgreSQL®