How can I speed up a SQL query? This video showcases how to optimize a SQL query on MySQL or PostgreSQL for free using AI and a tool called EverSQL by Aiven.

In the example shown, the query performance on a MySQL database went from 20 seconds to 0.5 seconds only by pasting the SQL and additional metadata in the EverSQL by Aiven UI and applying the indexes and SQL rewrite suggestions.

#mysql #postgresql #postgres #sql #optimization #performance #eversql

Check out these resources to learn more:
(links to any tools or resources you used in the video, our docs/trial if appropriate)

• Check out EverSQL.com https://go.aiven.io/aiven-video-sql-optimize-eversql
• Check out how to monitor a database and receive performance insights and optimization suggestions https://go.aiven.io/aiven-video-sql-optimize-eversql-aws

CHAPTERS

00:00 Intro

00:27 Visualize the data and the slow query

01:28 Upload the SQL and metadata to EverSQL by Aiven

02:43 Check EverSQL by Aiven AI-driven optimization suggestions

03:46 Apply the optimization suggestion and check the results

RESOURCES
Create your free Aiven account: https://go.aiven.io/youtube-signup

AIVEN DATA PLATFORM
The Aiven Platform is more than a collection of open source services for streaming, storing and analyzing data. The platform ensures that all services run reliably and securely in the clouds of your choice, are observable, and can easily be integrated with each other and with external 3rd party tools.

CONNECT WITH US
Website: http://aiven.io​​​
LinkedIn: https://www.linkedin.com/company/aiven/
GitHub: https://github.com/aiven​​​
X: https://twitter.com/aiven_io