Standalone single SQL query optimization [PostgreSQL & MySQL]
A fast way to optimize my PostgreSQL & MySQL queries automatically.
As a software engineer, I would like to submit my query and receive a newly rewritten version of the query, optimized to run 10 times faster. These optimizations could potentially save my team an average of 50 weekly hours, which are currently spent manually optimizing these queries.
I would like to perform these optimizations directly from Aiven's console, even if my Database is not hosted on Aiven yet.
Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.
AdminOded Valin
(Director of Product Management, Aiven.io)
shared this idea
Now available! https://aiven.io/tools/sql-query-optimizer and inside the Aiven console (under tools).
Please try it out and let us know if you got your query optimized.
-
As a database administrator or developer,
I would like the capability to create hypothetical indexes, test different indexing scenarios, explore various index configurations, experiment with indexes safely, evaluate the potential benefits of index creation or modification,
to facilitate tasks such as query optimization, supporting performance tuning, aiding index design, supporting testing and development, and aiding decision making.
