Verify If the EverSQL MySQL Tool Provides Good Optimization Suggestions: Lately in PHP 93 Part 7
Learn how to verify the efficiency of the MySQL query optimizations suggested by the EverSQL tool.
The link to the podcast article is in this video's comments.
1:00 Test the query being optimized before and after the optimization
1:20 Use the MySQL EXPLAIN SQL command to test the SQL query
2:09 Analyse the results of the EXPLAIN SQL query
5:12 Perform the database optimizations suggested by the EverSQL tool
5:32 Evaluate the optimization results comparing the EXPLAIN query results
The EverSQL MySQL optimization tool is excellent for suggesting alterations to MySQL tables and indexes to make SQL queries run faster.
The actual gains in performance may vary depending on the type of query. Significant SQL query optimizations reduce the number of table rows scanned when the MySQL server executes a query.
Watch this video of part 7 of episode 93 of the Lately in PHP podcast to learn how to verify the efficiency of the MySQL query optimizations suggested by the EverSQL tool.
Listen on Spotify: https://open.spotify.com/show/7nJyDle...
Music obtained with permission from: http://spoti.fi/NCS Sound effects obtained with permission from: https://www.zapsplat.com/
The link to the podcast article is in this video's comments.