Rewrite Your Complex MySQL Queries for Better Performance
summary
Shows how MySQL query optimizer can choose very different plans for equivalent SQL and demonstrates concrete rewrite techniques to get better performance. Covers transforming subqueries into more efficient forms, when to replace subqueries with window functions to speed up queries, and which of these rewrites MySQL 8.0 can perform automatically.
AI-written summary · about
related talks
21mWriting High Performance SQL Statements
54mPerformance Analysis and Optimization of MySQL
28mMysql Optimizer Features in 5.7 and 8.0
25mThe Secret Life of SQL: How to Optimize Database Performance
01mHow well do you know your MySQL Indexes?
41mMySQL Query Optimization Best Practices and Indexing
57mPerformance Analysis and Optimization of MySQL
55mLet's Talk About MySQL Query Tuning